ExcelBanter - how can I add +ve numbers only in a list of +ve and -ve numbers

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can I add +ve numbers only in a list of +ve and -ve numbers (https://www.excelbanter.com/excel-discussion-misc-queries/169051-how-can-i-add-ve-numbers-only-list-ve-ve-numbers.html)

Paul

how can I add +ve numbers only in a list of +ve and -ve numbers

T. Valko

how can I add +ve numbers only in a list of +ve and -ve numbers

=SUMIF(A1:A10,"0")

--
Biff
Microsoft Excel MVP

All times are GMT +1. The time now is 02:58 PM.