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

Wrong:

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

Right:

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

--
Biff
Microsoft Excel MVP


"Pran" wrote in message
...
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