Autosum results of multiple if statements?
 

I used multiple IF statements to return a number from 0 to 8. I now need to
sum the results of the returned numbers in a row. When I use =Sum(A7:J7) it
returns 0. How do I get a total on this Row?

Copy of statement
=IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0"))))

Autosum results of multiple if statements?
 

Your formula isn't returning numbers....
it's returning *letters* that look like numbers
=IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0"))))

Putting quotes around anything turns it into text.

Try this:
=IF(B3=$B$2+1,1,IF(B3=$B$2,2,IF(B3=$B$2-1,4,IF(B3=$B$2-2,8,0))))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Golf Nut" wrote:

I used multiple IF statements to return a number from 0 to 8. I now need to
sum the results of the returned numbers in a row. When I use =Sum(A7:J7) it
returns 0. How do I get a total on this Row?

Copy of statement
=IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0"))))

Autosum results of multiple if statements?
 

Remove the quotes from your numbers, since that makes them Text, and Sum()
ignores Text.

=IF(B3=$B$2+1,1,IF(B3=$B$2,2,IF(B3=$B$2-1,4,IF(B3=$B$2-2,8,0))))

OR,

Change your totaling formula to:

=A7+B7+C7+D7+E7+F7+G7+H7+I7+J7

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Golf Nut" <Golf wrote in message
...
I used multiple IF statements to return a number from 0 to 8. I now need
to
sum the results of the returned numbers in a row. When I use =Sum(A7:J7)
it
returns 0. How do I get a total on this Row?

Copy of statement
=IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0"))))