Thread: Sum only positive
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Sum only positive
try

=SUMIF(J8:J13,"0")

Change J8:J13 to suit your range

"Arne Hegefors" wrote:

Hi! I have a very long list of numbers. I want to get a sum of only the
positive numbers. Is there any way I can do this? Thanks!
Reply With QuoteReply With Quote