Thread: SUM ONLY NUMBERS IN A RANGE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default SUM ONLY NUMBERS IN A RANGE
Hi,
One way:
=SUMIF(C4:C11,"0")
If there are negative numbers in your list, then use a negative number much
larger than you will ever have. eg
=SUMIF(C4:C11,"-9E100")
Regards - Dave.
Reply With QuoteReply With Quote