How to sum only positive values in a column?

Z

zzapper

Hi
given a column say

10
-2
5.53
5.2
-27

How to sum ignoring the -2 -27 etc


(and then how to sum only the negatives)
 
Z

zzapper

Nick said:
zzapper

=SUMIF($A$1:$A$1000,">0")

or <0 for negatives. (Be aware tis will exclude zero so you may want to use
Click to expand...
Nick
Great just what I wanted.
Now how can I extend it such it SUMS only if adjacent Cell contains
"eBay Payment"
 
N

Nick Hodge

zzapper

That wasn't what you asked ;-)

=SUMPRODUCT(($A$1:$A$1000>=0)*($B$1:$B$1000="eBay Payment")*($A$1:$A$1000))

Should work

Remember the eBay Payment must be exactly the same in each cell and this now
looks for positives and zero, reverse the < for negatives

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
D

David Biddulph

I hope that the OP doesn't lose too much sleep trying to decide whether or
not to add the zeroes, Nick. :)
 
Z

zzapper

David said:
I hope that the OP doesn't lose too much sleep trying to decide whether or
not to add the zeroes, Nick. :)
Click to expand...

A multiple thank you for these various ways of solving my problem. Good
Newsgroup!

Haven't really played with a spreadsheet since Borland's Quattro!

zzapper
 
Top