ExcelBanter - formula(excel) to skip cells having

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

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

- - formula(excel) to skip cells having - number and add + one (https://www.excelbanter.com/excel-worksheet-functions/52174-formula-excel-skip-cells-having-number-add-one.html)

anthonylaw

formula(excel) to skip cells having - number and add + one

pls help me with the formula in excel to add up the cells having only positve
numbers and to skip the cells having a negative numbers.
thank u.

Bruno Campanini

formula(excel) to skip cells having - number and add + one

"anthonylaw" wrote in message
...
pls help me with the formula in excel to add up the cells having only
positve
numbers and to skip the cells having a negative numbers.
thank u.

=SUMIF(Range,"0")

Bruno

All times are GMT +1. The time now is 05:24 AM.