Sum of cell which use if array function

P

Pran

Hi,

I have many cells using if function which result is number.
I'd like to sum all of those cells, unfortunatelly i cant do that, the
result is none.

How can i solve this one?

Thank you
 
T

T. Valko

If your IF formulas contain quotes around numbers, REMOVE THEM.

Wrong:

=IF(A1="x","10","0")

Right:

=IF(A1="x",10,0)
 
Top