Calculate an Excel column that contains numbers and #Values
Hi Dave O
Thanks, but I can not get this to work, I am a bit of a beginer in Excel so
maybe I have not explained what I am trying to do properly.
ぎ18.00 #VALUE! #VALUE!
0 ぎ425.00 ぎ0.00 ﾂ｣0.00
ぎ18.00 #VALUE! #VALUE!
1 ぎ2,170.00 ぎ2,170.00 ﾂ｣1,446.67
Y 8 ぎ63.00 ぎ504.00 ﾂ｣336.00
1 ぎ460.00 ぎ460.00 ﾂ｣306.67
Y 8 ぎ40.00 ぎ320.00 ﾂ｣213.33
ぎ0.00 ﾂ｣0.00
ぎ0.00 ﾂ｣0.00
ぎ0.00 ﾂ｣0.00
ぎ0.00 ﾂ｣0.00
Total #VALUE! #VALUE!
As you can see above because the formula coming across is delivering a
#value (which is correct) I can not total the column. I need some way
ignoring the #Value so that I can total the column
"Dave O" wrote:
One strategy is to change the formulas that are returning #VALUE to an
IF statement, maybe something like this:
=IF(ISERROR(your formula here),"",your formula here)
This evaluates the formula and returns nothing if the formula returns
an error, but returns the formula's result if it is not an error.
|