Thread: Autosum results of multiple if statements?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Golf Nut Golf Nut is offline
external usenet poster
  
Posts: 2
Default 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"))))
Reply With QuoteReply With Quote