Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
Current Month | Excel Worksheet Functions | |||
Current Month Query | Excel Worksheet Functions | |||
UserForm to select current month or earlier | Excel Discussion (Misc queries) |