In my logbook, I have a totals page. What I'm trying to do is to total the flying time in a certain aircraft type for the last 6 months from todays date.
This is my setup:
Column A: DATE. Column B: AIRCRAFT. Column F: TIME.
9/1/10 LJ45 5.0
10/1/10 LJ60 1.9
1/2/11 LJ45 2.0
2/1/11 LJ60 1.9
Thanks for the help.
Jed
Last edited by fl510; 02-04-2011 at 11:20 AM.
Assuming you placed an aircraft reference in J2, put this formula in K2:
=SUMPRODUCT(--($A$1:$A$20>TODAY()-180),--($B$1:$B$20=J2), $F$1:$F$20)
Copy that down as you add more aircrafts to column J.
If you're a real stickler for exactly 6 months regardless of calendar month variances, then replace the red portion with this:
DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))
Last edited by JBeaucaire; 02-04-2011 at 11:07 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Worked great!! Thanks again.
Jed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks