SUMIF based on 2 conditions

[Guest]

Is there a way to do SUMIF to sum a column of number based on meeting 2
independent conditions rather than 1. (i.e. checking independent values or
conditrions in 2 different cells.)

 

[Paul Corrado]

=SUMPRODUCT(("rangea"="condition1)*("rangeb"="condition2")*("range to sum"))

Note all ranges must contain the same number of rows or columns.

With two columns of criteria and one column of data

=SUMPRODUCT(A1:A10="One")*(B1:B10=5)*(C1:C10))

 

[Guest]

Hi Tim,
Yes

Sumproduct() Introduction For - Great explanations!!
see http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[RagDyer]

To answer your original question, yes, there is a *way*.
And that "way" is to *add* the SUMIF()'s.

=SUMIF(A1:A100,D1)+SUMIF(A1:A100,D2)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Is there a way to do SUMIF to sum a column of number based on meeting 2
independent conditions rather than 1. (i.e. checking independent values or
conditrions in 2 different cells.)