Sum of cell which use if array function

  • Thread starter Thread starter Pran
  • Start date Start date
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
 
If your IF formulas contain quotes around numbers, REMOVE THEM.

Wrong:

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

Right:

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