Thread: summing positive values (cells) in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vinayak Bhat Vinayak Bhat is offline
external usenet poster
  
Posts: 1
Default summing positive values (cells) in excel
I want to sum the positive values in a range.

I named the range and tried as follows but it doesnot work. Please advise.

=sum(if (list0,list,0))

Vinayak
Reply With QuoteReply With Quote