sum if true and certain month

[mbsmeltzer]

Can you please help me produce 200 as the answer for total of all deposits received for the month of January regardless of year? A received deposit being one that is true as in the example.

[AliGW]

Try this:

=SUMPRODUCT((MONTH($B$2:$B$5)=1)*($C$2:$C$5))

You seem to have 3 January dates in your sample workbook.

[mbsmeltzer]

Thanks for helping Ali. I need the formula to also consider if column A is True. That's why the total should only be 200 and not 300.

[AliGW]

That wasn't clear in your opening post.

This, then:

=SUMPRODUCT((MONTH($B$2:$B$5)=1)*($A$2:$A$5="TRUE")*($C$2:$C$5))

[mbsmeltzer]

That only produces 0 for me...

[mbsmeltzer]

oh, I got it! I changed ="TRUE" to >""

Thank you Ali!

[AliGW]

Look:

Excel 2016 (Windows) 32 bit

	A	B	C
1	Received	Date	Amount
2	True	05/01/2019	100
3		08/01/2019	100
4		05/02/2020	100
5	True	08/01/2020	100
6
7	received in January		200

Sheet: Hoja1

Excel 2016 (Windows) 32 bit

	C
7	=SUMPRODUCT((MONTH($B$2:$B$5)=1)*($A$2:$A$5="TRUE")*($C$2:$C$5))

Sheet: Hoja1

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.