Thread: Summing it up
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Violet 1 Violet 1 is offline
external usenet poster
  
Posts: 3
Default Summing it up
That did it! Awesome - Thanks!!!

"TomPl" wrote:

=IF(O27=0,"","8") returns the text value 8.
To get the number 8 change the formula to:
=IF(O27=0,"",8)
Then you sum formula should work.

tom
Reply With QuoteReply With Quote