sum product checking a range

[SalamanderSam14]

=SUMPRODUCT((MONTH($A$7:$A$100)=MONTH(A8))*($E$7:$E$100=E8)*($D$7:$D$100))

This is my formula as it stands, i want to breaK IT UP SO IT LOOKS AT QUATER OF A YEAR
My quater are basked around the dates

1st May- 31st july
1st aug - 31st oct
1st nov - 31st jan
1st feb - 30th april

i tried the following formula with no success
=SUMPRODUCT((MONTH($A$7:$A$100)>=MONTH(A8)AND (MONTH($A$7:$A$100)>=MONTH(b8))*($E$7:$E$100=E8)*($D$7:$D$100))


any suggestions are appriciated

[Pete_UK]

You can't use AND with arrays. Try it this way:

=SUMPRODUCT((MONTH($A$7:$A$100)>=MONTH(A8))*(MONTH($A$7:$A$100)>=MONTH(b8))*($E$7:$E$100=E8)*($D$7:$D$100))

I'm not sure this will work properly, though, as one of your quarters spans two years, so you might have to incorporate a year function as well.

Hope this helps.

Pete

EDIT: Also, I think your second comparison should be <=MONTH(b8), although you've not really said what A8 and B8 contain