ignore #N/A in a sum?
I am adding three columns +F160+G160-H160
Doesn't look like you're adding H160?
=SUMIF(F160:H160,"<#N/A")
Biff
"Todd" wrote in message
...
I have a worksheett that has many #N/A's where a matching formula brought
over data. It there is no match I get another N/A's. Thats ok, but I
need
to sum accross the rows and I don't want to remove the formula.
I am adding three columns +F160+G160-H160
Is there a formula I can use? Or do I really need to delete all the
N/A's.
( I will just have to put them back later if I do).
Thanks,
Todd
|