+TSRA
2nd Nov 2007, 21:33
Hi all,
Im quite proud of myself in my abilities at programming but have come up against an unexpected problem with my self made logbook in excel.
I want to be able to pull from my data the last 30, 90, 180 and 360 days worth of flight times. I would have thought this would have involved a simple sumif formula, but it always comes back #ref or invalid :ugh:
for example I have tried
=sumif('logbook'a6:A1400,"",g6:r1400)
where A column equals the date of the flight and
G through R equal all the flight columns (Day, Night, PIC, SIC, etc)
and other variations on the SUM, SUMIF, IF etc formulae.
Ive had a friend who was able to do it all with a macro but it is not able to self-up-date with each new flight, making it useless as a record keeping device (considering I would have to re-write to code for each flight, assuming I understood Macro code...)
Im hoping someout out there has overcome this problem and could steer me in the right direction. For me this is a last resort asking, but after 10 months of trying I figure its time to be a man and ask for help...
but dont let my wife know...:}
Sorry about the prev. edition of this post!!!!:\
Im quite proud of myself in my abilities at programming but have come up against an unexpected problem with my self made logbook in excel.
I want to be able to pull from my data the last 30, 90, 180 and 360 days worth of flight times. I would have thought this would have involved a simple sumif formula, but it always comes back #ref or invalid :ugh:
for example I have tried
=sumif('logbook'a6:A1400,"",g6:r1400)
where A column equals the date of the flight and
G through R equal all the flight columns (Day, Night, PIC, SIC, etc)
and other variations on the SUM, SUMIF, IF etc formulae.
Ive had a friend who was able to do it all with a macro but it is not able to self-up-date with each new flight, making it useless as a record keeping device (considering I would have to re-write to code for each flight, assuming I understood Macro code...)
Im hoping someout out there has overcome this problem and could steer me in the right direction. For me this is a last resort asking, but after 10 months of trying I figure its time to be a man and ask for help...
but dont let my wife know...:}
Sorry about the prev. edition of this post!!!!:\