check day as well as month

K

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..
 
G

Guest

Hi

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