Calculating numbers of expiring accounts based on month and location

[fredieusa]

Hello Everyone,
I am so stumped and need help. How do I calculate how many accounts are expiring in March from Anaheim? Looking at a formula to calculate the yellow-highlighted area. Thank you so much !!

 

[AliGW]

In F8 copied across:

=SUMPRODUCT((MONTH($C$3:$C$227)=MONTH($E8))*(YEAR($C$3:$C$227)=YEAR($E8))*($B$3:$B$227=F$2))

If you have 365, there may be a SPILL formula, but you don't say.

 

[fredieusa]

In F8 copied across:

=SUMPRODUCT((MONTH($C$3:$C$227)=MONTH($E8))*(YEAR($C$3:$C$227)=YEAR($E8))*($B$3:$B$227=F$2))

If you have 365, there may be a SPILL formula, but you don't say.

Hi AliGW, Yes I do have 365. For an expanding list of accounts, I have changed the $c$227 to $c$500. Is there a neater way?
=SUMPRODUCT((MONTH($C$3:$C$500)=MONTH($E8))*(YEAR($C$3:$C$500)=YEAR($E8))*($B$3:$B$500=F$2))