ExcelBanter - Adding only positive numbers

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

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

- - Adding only positive numbers (https://www.excelbanter.com/excel-discussion-misc-queries/139564-adding-only-positive-numbers.html)

biscuitsmom

Adding only positive numbers

I have 2 columns of numbers. I want to add column 2 to column 1 but only if
the number in column 2 is a positive number. How do I do this?

Toppers

Adding only positive numbers

Columns A & B

in C1:

=IF(B10,A1+B1,"")

If B <= 0, result is blank.

Is this what you want?

If you want answer in column A, then you will need VBA.

HTH

"biscuitsmom" wrote:

I have 2 columns of numbers. I want to add column 2 to column 1 but only if
the number in column 2 is a positive number. How do I do this?

All times are GMT +1. The time now is 08:51 PM.