View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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?