Thanks:  0
Likes:  0

# Thread: adding positive numbers in a column of positives and negativ

1. I have a column of positive and negative numbers. I would lik eto summate only the positive numbers and ignore the negative numbers . Is it possible with excel?

Thanks

2. On 2002-05-08 21:42, sky wrote:
I have a column of positive and negative numbers. I would lik eto summate only the positive numbers and ignore the negative numbers . Is it possible with excel?

Thanks
Let us say your numbers arte in column A, then use

=SUMIF(A:A,">0")

Hope This Helps!

3. To Yogi,

eg: a1:a4 = -1,2,-3,4

I only want to summate the positives giving a total of 6. I have tried a:a>"0", it does not work.

Help!

4. On 2002-05-08 21:54, sky wrote:
To Yogi,

eg: a1:a4 = -1,2,-3,4

I only want to summate the positives giving a total of 6. I have tried a:a>"0", it does not work.
Hi SKY:
You have perhaps entered the formula incorrectly. Please reenter the formula as:

=SUMIF(A:A,">0")
or
=SUMIF(A1:A4,">0")

and with your entries the result should be 6

Regards!

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 13:13 ]

## User Tag List

#### Posting Permissions

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