Summing Values In Current Month Only

[qflyer]

Hey guys,

I have my pilot's logbook in a spreadsheet, and I'd like to total
flight time in the current month only.

Column A is the date of each flight.
Column Q is the amount of flight time on that flight.

So I want to know my flight time in June of 2005, which is done simply
enough with
=SUMPRODUCT(--(MONTH(A50:A3000)=6),--(YEAR(A50:A3000)=2005),Q50:Q3000)

Is there a formula I can use that automatically updates the current
month and year without me having to enter it myself? When July comes
around, I'd like the formula to just look at the month of July
automatically without me changing the formula to
=SUMPRODUCT(--(MONTH(A50:A3000)=7),--(YEAR(A50:A3000)=2005),Q50:Q3000)

Hope my description isn't too unclear.

Thanks,
Scott

 

[Biff]

Hi!

Replace =6 with:

=MONTH(TODAY())

And replace =2005 with:

=YEAR(TODAY())

Biff

 

[Peo Sjoblom]

Sure, one way

=SUMPRODUCT(--(MONTH(A50:A3000)=MONTH(TODAY())),--(YEAR(A50:A3000)=YEAR(TODAY())),Q50:Q3000)


--
Regards,

Peo Sjoblom

(No private emails please)

 

[qflyer]

That was simple enough...now why didn't I think of that, lol.

Thank you both

Scott