SUMIFS by multiple criteria

[lopezcrazy]

I have a "SUMIFS" formula that's returning a black cell.

My formula: =IF(MONTH(G1)=MONTH(NOW()),SUMIF(C150:C150,"Rent",D150:D150),"")

I'm wanting to create a formula that will sum up the values in D:D
BUT only if they are in the "Food" category
AND only if it's in the current month (G1)

Can anyone help me out?

 

[mrshl9898]

Nearly there. =IF(MONTH($G$1)=MONTH(NOW()),SUMIF(C:C,G2,D:D),"")

 

[jtakw]

Hi,

Assuming your Table Column A contains Other months not shown in your picture, also assuming the "Number" in G1 is a Real Number:

Formula in H2 copied down:

=SUMPRODUCT((MONTH(A$2:A$200)=G$1)*(C$2:C$200=G2)*(D$2:D$200))