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
|