Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

SwearBear wrote:

David,

What the heck is a "double uanry minus" and what does it do?

--
Sociopath

"David Biddulph" wrote:

A minor point, but are you sure that you need the double unary minus on the
column H term? Doesn't the addition do the job of coercing to a number?
--
David Biddulph

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--((H3:H200="AA 250")+(H3:H200="AA
251")),--(F3:F200<"sent"),E3:E200)

"Ann" wrote in message
...
sorry you are correct, i have misposted this question in this thread and
in
the other one i started. i apologize and thank you for your help.

=SUMPRODUCT(--(H3:H200="AA 250"),--(F3:F200<"sent"),E3:E200)

i want to add in "AA 250" or "AA 251" for this statement as the sum of
these
should be together, the rest I've got.

thanks again.

"Bob Phillips" wrote:

Do you mean

=IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Ann" wrote in message
...
had a follow up.

if column C is one of 4 statements. how do i use both?
for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200)










--

Dave Peterson