| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help adding up hour totals on a logbook
THANKS!! Sheeloo works perfect your a star :D
"Sheeloo" wrote: There are a number of posts in this forum which give similar solutions using SUMPRODUCT function. Try to search for them Basically you have to enter a formula like this one to get the totals; =SUMPRODUCT(--(A1:A100="B747-300"),(R1:R100)) Adjust the range according to your data points. In Excel 2007 you can use A:A and R:R for range... "joe1999" wrote: 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
