if then statement based on another column

[Ann]

i'm trying to use this formula =SUMIF(B1:B200,"<>sent",A1:A200)
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)

 

[Rick Rothstein \(MVP - VB\)]

I provided you with an answer to this same question 12 minutes before you
repeat-posted here again, in as a new thread. In the future, please stay
with your original thread for follow ups and, by all means, check the
responses you get to your original questions.

Rick

 

[PCLIVE]

Ann,
Maybe SUMPRODUCT is what you want:
=SUMPRODUCT(--(C1:C200="A"),--(B1:B200<>"sent"),A1:A200)

HTH,
Paul

 

[Ann]

sorry, i messed up. i had already posted your response answered my question,
but then had a follow up. sorry again.

 

[Ann]

this helps. another follow up - what if it it's "A" or "B". i can't get the
syntax right.

 

[PCLIVE]

Try this:

=SUMPRODUCT(--(C1:C200="A")+(C1:C200="B"),--(B1:B200<>"sent"),A1:A200)

Regards,
Paul

--

 

[Ann]

this works, thanks!

Try this:

=SUMPRODUCT(--(C1:C200="A")+(C1:C200="B"),--(B1:B200<>"sent"),A1:A200)

Regards,
Paul