J
joe1999
Hi,
I have created a logbook to log my flights and want to add up different
aircraft totals.
example column A2 contains type eg B747-300, B747-400 etc.
Column R2 contains flight time.
I was trying to create a formula that looks at A2 and if it contains say
B747-300 then put the value of R2 in a new table column -300, similarly for
the -400 etc.
so I can get the totals for each type, hope this makes sense????
I have created a logbook to log my flights and want to add up different
aircraft totals.
example column A2 contains type eg B747-300, B747-400 etc.
Column R2 contains flight time.
I was trying to create a formula that looks at A2 and if it contains say
B747-300 then put the value of R2 in a new table column -300, similarly for
the -400 etc.
so I can get the totals for each type, hope this makes sense????