Thread: adding result of "if" statement..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xiamen Xiamen is offline
external usenet poster
  
Posts: 1
Default adding result of "if" statement..
I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0",
IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0", IF(G17=(""),""
)))))))

Now i want to add the result of this statement from consecutive rows.
i did sum on the results but i am not able to add the results of my
statements.

can you tell me how i can add the results of this statement?
Reply With QuoteReply With Quote