SUMIF with 2 conditions

[aufantastic]

I want to calculate a sumif statement in a spreadsheet but I want to have two sets of conditions. It must match what is in one cell and then another. Can you help?

 

[texasalynn]

=sumproduct((b1:b100="Condition1")*(c1:c100="Condition2")*(D1:d100))

 

[Jon von der Heyden]

Hello

Could you please be more specific (i.e. ranges and criteria).

As an example:

=SUMPRODUCT(--(A10:100=A1),--(B10:B100=B1),C1:C100)

Where the criteria are in A1 and B1, and the sum range in column C

Note, unless using versions later than (and incl.) 2007 do not use whole columns (so no C:C).

 

[aufantastic]

I still need help guys. Sorry, I guess I am confused.

I have one column with up to 28 different values in it.

I have a second column with only 2 different values in it.

I will need to end up with 56 different totals based on each of the 28 restaurants with up to 2 different rates.

That is what I am trying to do.

Thanks, Tim

 

[aufantastic]

=sumproduct((b1:b100="Condition1")*(c1:c100="Condition2")*(D1:d100))

Please see my posted reply in my thread.
Thanks.

 

[texasalynn]

sounds like you could use pivot table
with column a in the rows and column b in the data

HTH

 

[Spielmann]

See this site:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html