Sum Amount if two conditions are met

G

Gary

I am having trouble with a formula. I am looking to sum dollar amounts in
column C when conditions for columns A & B are met.

Can someone please assist?

Thanks,

Gary
 
P

PCLIVE

One way:

=SUMPRODUCT(--(A1:A10="condition1"),--(B1:B10="Condition2"),C1:C10)

HTH,
Paul
 
R

Roger Govier

Hi Gary

One way
=SUMPRODUCT(($A$1:$A$100="condition1")*($B$1:$B$100="condition2")*$C$1:$C$100)

Change ranges to suit, but ensure they are of equal length (you can't
use whole columns in Sumproduct).
If your conditions are numeric, don't enclose them in quotes. If they
are text, then use quotes.
Equally you put your conditions in cells and refer to the cells

=SUMPRODUCT(($A$1:$A$100=$F$1)*($B$1:$B$100=$G$1)*$C$1:$C$100)
 
E

Elkar

The SUMPRODUCT function would probably work best for you. Something like:

=SUMPRODUCT(--(A1:A100="condition1"),--(B1:B100="condition2"),C1:C100)

This will check for "condition1" in column A and "condition2" in column B.
If both conditions return as TRUE, then column C will be added.

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top