Sumifs with multiple ifs

[drluke]

A001	1	AC FEE	20.00
A001	1	MEDIA	16.89
A001	1	PROJ M	39.42
A001	1	M FEE	10.12
I want a sumifs with a multi conditional IF that will sum (col D) if:
(a) col A = A001, and
(b) col B = 1, and
(c) col C = AC Fee or M Fee
or do nothing.

<colgroup><col width="64" style="width: 48pt;" span="7"> <tbody> </tbody>

 

[tharrington]

I would try an if or statement with those conditions, and then the value if true as the sum of the column, and "" if false


Ex: if(or(A:A = "A001",...),sum(D:D),"")

 

[Marcelo Branco]

Try

=SUM(SUMIFS(D:D,A:A,"A001",B:B,1,C:C,{"AC FEE";"M FEE"}))

M.

 

[MARZIOTULLIO]

Hi

=SUMIFS($D$2:$D$5,$A$2:$A$5,A2,$B$2:$B$5,B2,$C$2:$C$5,"*Fee")