Multiple Criterion in a SUMIF function
Is this formula not multiplying? I am trying only to sum a data set that
meets 2 conditions.
--
iperlovsky
"Teethless mama" wrote:
=SUMPRODUCT(--((A2:A200=C2)+(A2:A200=E2))*B2:B200)
"IPerlovsky" wrote:
How would I incorporate 2 criterion into the SUMIF function? For example, in
the following example I have the formula look to the A2:A2000 range for the
value referrenced in C2 and sum only those numbers in range B2:B2000 that
meet this criteria. That's the easy part. How would I add another layer of
criteria to the formula below in addition to that specified by "C2" - say,
EXACT(E2,VLOOKUP(E1,A2:B2000,2,FALSE))=TRUE?
=SUMIF(B2:B2000,E2,C2:C2000)
thx.
--
iperlovsky
|