[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Excel question



PureBytes Links

Trading Reference Links

There is a sumif function. Sum over the range ignoring values that
="#Value". Check the help menu for more syntax.

-----Original Message-----
From: cwest [mailto:cwest@xxxxxxxxxxxx]
Sent: Monday, October 13, 2003 5:16 PM
To: omega-list@xxxxxxxxxx
Subject: Excel question


I have many columns of numbers I want to sum, but several of the cells
contain #VALUE!. They didn't resolve from other calculations. Is there a
way to exclude the cells that have #VALUE! as manually fixing them would
be too tedious?

Thanks in advance
Colin West