if then statement based on another column
 

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)

if then statement based on another column
 

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

"Ann" wrote in message
...
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)

if then statement based on another column
 

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

HTH,
Paul

--

"Ann" wrote in message
...
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)

if then statement based on another column
 

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

"Rick Rothstein (MVP - VB)" wrote:

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

"Ann" wrote in message
...
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)

if then statement based on another column
 

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

"PCLIVE" wrote:

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

HTH,
Paul

--

"Ann" wrote in message
...
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)

if then statement based on another column
 

Try this:

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

Regards,
Paul

--

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

"PCLIVE" wrote:

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

HTH,
Paul

--

"Ann" wrote in message
...
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)

if then statement based on another column
 

this works, thanks!

"PCLIVE" wrote:

Try this:

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

Regards,
Paul

--

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

"PCLIVE" wrote:

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

HTH,
Paul

--

"Ann" wrote in message
...
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)