Sumproduct across cells conditional upon date?

[TGill]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Savage[/TD]
[TD]12/04/15[/TD]
[TD]29,699.59[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Huntington[/TD]
[TD]12/09/15[/TD]
[TD]27,725.74[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Prestige[/TD]
[TD]12/23/15[/TD]
[TD]12,869.39[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Concord[/TD]
[TD]01/27/16[/TD]
[TD]22,807.85[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Kelly[/TD]
[TD]02/01/16[/TD]
[TD]4,833.24[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Burlington[/TD]
[TD]02/04/16[/TD]
[TD]5,695.15[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]12/01/15[/TD]
[TD][/TD]
[TD]70,294.72[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]01/01/16[/TD]
[TD][/TD]
[TD]22,807.85
[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]02/01/16[/TD]
[TD][/TD]
[TD]10,528.39[/TD]
[/TR]
</tbody>[/TABLE]

Trying to get a formula to come up with the figures in RED above. This is a very small fragment of a very large spreadsheet. Need to sum up the figures in column C based on the month & year of column B that have the same month & year of column A.

Searched around, found several Sumproduct uses for various worksheets, but couldn't get any of them to work here.

Thanks in advance.

 

[Marcelo Branco]

Try

C8 copied down
=SUMPRODUCT(--(YEAR($B$1:$B$6)=YEAR(A8)),--(MONTH($B$1:$B$6)=MONTH(A8)),$C$1:$C$6)

Hope this helps

M.

 

[Joyner]

Just another option for fun. My understanding is SUMPRODUCT calculates quicker, but I may be wrong:

=SUMIFS($C$1:$C$6,$B$1:$B$6,">="&A8,$B$1:$B$6,"<="&EOMONTH(A8,0))

 

[TGill]

THANK YOU, M!!!!!! Works like a charm.