| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding totals to new sheet | Excel Worksheet Functions | |||
| Adding totals after filtering | Excel Discussion (Misc queries) | |||
| Adding time over a 24 hour period | Excel Discussion (Misc queries) | |||
| Adding on a 24 hour clock basis | Excel Worksheet Functions | |||
| Adding category totals | Excel Worksheet Functions | |||
Threaded Mode
