=SUM issue

[CrazyCanuck]

I'm using the formulas below to calculate wins and losses and ties, but when I try to add them after in another cell with =SUM they don't add up it shows "0". What do I need to do to be able to add up these cells?

=IF(B2>D2,"1","") Win
=IF(B2<D2,"1","") Lose
=IF(AND(B2=D2,B2<>"",D2<>""),"1","") Tie (but not empty cells)

 

[etaf]

the "1" is text and not a number
change to just 1
=IF(B2>D2,1,"") Win
then it will sum
=IF(B2<D2,1,"") Lose
=IF(AND(B2=D2,B2<>"",D2<>""),1,"") Tie (but not empty cells)

 

[CrazyCanuck]

the "1" is text and not a number
change to just 1
=IF(B2>D2,1,"") Win
then it will sum
=IF(B2<D2,1,"") Lose
=IF(AND(B2=D2,B2<>"",D2<>""),1,"") Tie (but not empty cells)

Perfect. Thank you

 

[etaf]

you are welcome