Array Gone Awry

[Guest]

Hello –

colA colB colC
R1 A X 2
R2 A Y 1
R3 B Y 0
R4 B Z 4

{=SUM(IF(A1:A4={"A"},C1:C4,0))} = 3

Correct…

Searching for way to sum colC based on multiple criteria.
How to sum colC for every A in colA that has an associated Y in colB.?

{ =SUM(IF(A1:B4={"A","Y"},C1:C4,0))} doesn’t do it…

Will keep searching KB…

Arturo

 

[Erin Kotch]

{=SUM(IF(A1:A4={"A"},if(B1:B4="Y",C1:C4,0),0))}

You make if B=Y another IF statement if A=A is true.

Hope this helps

Erin

 

[Ron Rosenfeld]

Hello –

colA colB colC
R1 A X 2
R2 A Y 1
R3 B Y 0
R4 B Z 4

{=SUM(IF(A1:A4={"A"},C1:C4,0))} = 3

Correct…

Searching for way to sum colC based on multiple criteria.
How to sum colC for every A in colA that has an associated Y in colB.?

{ =SUM(IF(A1:B4={"A","Y"},C1:C4,0))} doesn’t do it…

Will keep searching KB…

Arturo

=SUMPRODUCT((A1:A4="A")*(B1:B4="Y")*C1:C4)



--ron

 

[Daniel.M]

Hi,

Searching for way to sum colC based on multiple criteria.
How to sum colC for every A in colA that has an associated Y in colB.?

{ =SUM(IF(A1:B4={"A","Y"},C1:C4,0))} doesn’t do it…

For multiple criterias, use sumproduct(), as in:

=SUMPRODUCT((A1:A4="A")*(B1:B4="Y"),C1:C4)

Regards,

Daniel M.