Summing Values In Current Month Only
 

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


--
qflyer
------------------------------------------------------------------------
qflyer's Profile: http://www.excelforum.com/member.php...o&userid=24448
View this thread: http://www.excelforum.com/showthread...hreadid=382376

Hi!

Replace =6 with:

=MONTH(TODAY())

And replace =2005 with:

=YEAR(TODAY())

Biff

"qflyer" wrote in
message ...

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


--
qflyer
------------------------------------------------------------------------
qflyer's Profile:
http://www.excelforum.com/member.php...o&userid=24448
View this thread: http://www.excelforum.com/showthread...hreadid=382376

Sure, one way

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


--
Regards,

Peo Sjoblom

(No private emails please)


"qflyer" wrote in
message ...

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


--
qflyer
------------------------------------------------------------------------
qflyer's Profile:
http://www.excelforum.com/member.php...o&userid=24448
View this thread: http://www.excelforum.com/showthread...hreadid=382376

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

Thank you both

Scott


--
qflyer
------------------------------------------------------------------------
qflyer's Profile: http://www.excelforum.com/member.php...o&userid=24448
View this thread: http://www.excelforum.com/showthread...hreadid=382376