ExcelBanter - Excel Formula - Add column of numbers but ignore negative numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Formula - Add column of numbers but ignore negative numbers (https://www.excelbanter.com/excel-worksheet-functions/82047-excel-formula-add-column-numbers-but-ignore-negative-numbers.html)

view for Distribution List members

Excel Formula - Add column of numbers but ignore negative numbers

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

bpeltzer

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

All times are GMT +1. The time now is 06:27 PM.