IF function

  • Thread starter Thread starter Marcus Hughes
  • Start date Start date
M

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
 
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")
 
This is an array formula. entered by Ctrl+Shift+Enter:
=SUM(IF(A1:A5000,1))
When entered properly, XL will add the "curly brackets".
 
Back
Top