Thread: If Statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default If Statements
Use SUMIF:

=SUMIF(A1:A20,"0")

HTH

"DeckyT" wrote:

Hi all,

I have three columns. In the three columns there are positive and negative
values. How do i sum across only positve values??
--
Regards,

DeckyT
Reply With QuoteReply With Quote