IF function

[Marcus Hughes]

In an excel spreadsheet with an IF function that returns
either the value 1 or 0. How can i then sum the values of
multiple if functions. If I try to do this all i get is
0. Presumably, the SUM function does not see the 1 an 0
from the IF statement as numeric values merely text.

Any ideas

Thanks Marcus

 

[Ron de Bruin]

with this for example I have no problem to sum
=IF(B2>10,1,0)

Or do you use this
=IF(B2>10,"1","0")

 

[EZ Money]

This is an array formula. entered by Ctrl+Shift+Enter:
=SUM(IF(A1:A5000,1))
When entered properly, XL will add the "curly brackets".