Sum of positive values only using 'IF'

yippdr · #1 (**permalink**) 01-13-04, 20:00

I have a column of numbers that can have negative and positive values but I need a formula that adds only the positive values from the column. Right now I have tried =SUM(IF('range'>0,'range' but the numbers are not adding up properly.
ANy thoughts out there?

Thanks,
Dave

Bustamante · #2 (**permalink**) 01-13-04, 20:36

I wouldn't use 'IF', I would use 'SUMIF()' instead, this way you can set any criteria you want.

Eg:

=SUMIF(A1:A10,">0",A1:A10) don't forget quoting your criteria.

This simple formula will add only the positive values from your range.

I hope this can help.

Bustamante

Quote:

Originally posted by yippdr
I have a column of numbers that can have negative and positive values but I need a formula that adds only the positive values from the column. Right now I have tried =SUM(IF('range'>0,'range' but the numbers are not adding up properly.
ANy thoughts out there?

Thanks,
Dave

yippdr · #3 (**permalink**) 01-14-04, 13:03

You rule! Thanks so much!
Dave

Quote:

Originally posted by Bustamante
I wouldn't use 'IF', I would use 'SUMIF()' instead, this way you can set any criteria you want.

Eg:

=SUMIF(A1:A10,">0",A1:A10) don't forget quoting your criteria.

This simple formula will add only the positive values from your range.

I hope this can help.

Bustamante

Internet Services

Web Development

Digital Marketing

Consumer Tech