View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joe1999 joe1999 is offline
external usenet poster
 
Posts: 4
Default help adding up hour totals on a logbook

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????