Sumproduct across cells conditional upon date?

[TGill]

	A	B	C
1	Savage	12/04/15	29,699.59
2	Huntington	12/09/15	27,725.74
3	Prestige	12/23/15	12,869.39
4	Concord	01/27/16	22,807.85
5	Kelly	02/01/16	4,833.24
6	Burlington	02/04/16	5,695.15
7
8	12/01/15		70,294.72
9	01/01/16		22,807.85
10	02/01/16		10,528.39

<tbody>
</tbody>

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.