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
DTHIS
www.nickhodge.co.uk


"zzapper" wrote in message
ups.com...

Nick Hodge wrote:

zzapper

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

or <0 for negatives. (Be aware tis will exclude zero so you may want to
use
=0

--
HTH
Nick Hodge
Microsoft MVP - Excel
Nick
Great just what I wanted.
Now how can I extend it such it SUMS only if adjacent Cell contains
"eBay Payment"

--
zzapper
Best of VimTips
http://www.vim.org/tips/tip.php?tip_id=305