check day as well as month

[kaplonk]

I have this line:
=SUMPRODUCT(--(MONTH(A2:A45)=4),F2:F45)
that checks the date column for a match of the month of April then add
all entries in column F

However I need this to be more specific. I need to be able to check fo
quarterly periods i.e. from 5 April to 4 July.
I can't seem to get the formula right..

 

[Guest]

Hi

You could try something like:
=SUMPRODUCT(--(A2:A45>=G1)*(A2:A45<=G2)*(F2:F45))
with your dates in G1 and G2

 

[kaplonk]

hey thanks!
that worked

 

[Guest]

Thanks for the feedback!