Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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.) |
#2
![]() |
|||
|
|||
![]()
=SUMPRODUCT(("rangea"="condition1)*("rangeb"="cond ition2")*("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)) "TimH" wrote in message ... 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.) |
#3
![]() |
|||
|
|||
![]()
Hi Tim,
Yes Sumproduct() Introduction For - Great explanations!! see http://www.xldynamic.com/source/xld.SUMPRODUCT.html "TimH" wrote: 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.) |
#4
![]() |
|||
|
|||
![]()
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! ============================================== "TimH" wrote in message ... 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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF with two conditions ? | Excel Discussion (Misc queries) | |||
Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
formula based on format | Excel Discussion (Misc queries) | |||
counting based on 2 conditions | Excel Discussion (Misc queries) |