# Thread: Sum of positive values only using 'IF'

1. Registered User
Join Date
Jan 2004
Posts
2

## Unanswered: Sum of positive values only using 'IF'

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

2. Registered User
Join Date
Jan 2004
Location
Mexico
Posts
3

## Re: Sum of positive values only using 'IF'

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

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

3. Registered User
Join Date
Jan 2004
Posts
2

## Re: Sum of positive values only using 'IF'

You rule! Thanks so much!
Dave
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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•