Thread: Excel Formula - Add column of numbers but ignore negative numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Excel Formula - Add column of numbers but ignore negative numbers
If your numbers are in column A, =SUMIF(A:A,"=0",A:A)

"view for Distribution List members" wrote:

Help with a formula please - how do I add a column of numbers but
exclude/ignore any numbers with a negative value?

Thanks in advace
Reply With QuoteReply With Quote