P
Pantryman
Hi,
I'm writing a pilots logbook, where flights are listed starting wit
the date, then followed by several data fields on that same row.
Now, one cell per row ofcourse contains the aircraft type (e.g
B747-400) but several other aircraft types are flown, and I would lik
to determine how many hours are flown per type.
I'd like to do a vertical search in the 'type' column, then for exampl
get the hour flown on that type/that day or the amount of landings mad
and add that up to get the total results. I can do this ofcourse fo
the first matching return, that's easy but I don't know how to get al
the typematching hours added up.
I am lost here, can anyone help me?
I have spent days crunching my head, as I'm too green with excel yet
think.
Sorry if this is way too obvious, but I can't figure it out.
I can't seem to construct anything with any LOOKUP's, MATCH or OFFSE
that works.
Thanks a lot in advance.
P
I'm writing a pilots logbook, where flights are listed starting wit
the date, then followed by several data fields on that same row.
Now, one cell per row ofcourse contains the aircraft type (e.g
B747-400) but several other aircraft types are flown, and I would lik
to determine how many hours are flown per type.
I'd like to do a vertical search in the 'type' column, then for exampl
get the hour flown on that type/that day or the amount of landings mad
and add that up to get the total results. I can do this ofcourse fo
the first matching return, that's easy but I don't know how to get al
the typematching hours added up.
I am lost here, can anyone help me?
I have spent days crunching my head, as I'm too green with excel yet
think.
Sorry if this is way too obvious, but I can't figure it out.
I can't seem to construct anything with any LOOKUP's, MATCH or OFFSE
that works.
Thanks a lot in advance.
P