Great. This makes a lot of sense.

John

"Tom Ogilvy" wrote in message
...
For Bounce or Return

=SUM(SUMIF(B1:B200,{"bounce","return"},A1:A200))
or
=Sumif(B1:B200,"bounce",A1:A200)+Sumif(B1:B200,"re turn",A1:A200)

or
=sumproduct((B1:B200="Bounce")+(B1:B200="Return"), A1:A200)

for not equal to either, this does NOT work:
=SUM(SUMIF(B1:B200,{"<bounce","<return"},A1:A200 ))

This will work

=Sum(A1:A200)-SUM(SUMIF(B1:B200,{"bounce","return"},A1:A200))


--
Regards,
Tom Ogilvy


"jb" wrote:

On a similar note, how do you do a compound criteria? That is, in the
below
example, if I wanted to get all "Bounce" and all "Return", how do I
specify
the Criteria? I tried "=Bounce OR Return", "=Bounce" OR "=Return" but
neither of those worked.

Also, trying to use not equal <, how do you use AND or OR like <Bounce
And
< Return?

Thanks for your help.

John

"Jim Cone" wrote in message
...

With the data in B5:C10...
=SUMIF(C6:C10,"0",B6:B10)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"jb"
wrote in message
Hello,
I need to do a dsum with a criteria of Isnumber(Check Number Column).
I
do
not know how to put a criteria in where I can return values only for
those
rows where there is a number in another column.
Paid Check #
$100 1234
$200 Bounce
$300 4567
$400 Return
$500 7777
I need a dsum to come back with $900 which are the 3 numeric looking
Check
#'s. I can't figure out how to put the criteria in.
Thank you.