pilot flying logbook

stevenpengilly

Board Regular
Joined
Dec 17, 2004
Messages
52
Sorry another question but everybody has been very helpful in the past. I have got my Flying logbooks on excel and they work fine. The problem is that over the last 30 years I have flown more than 30 different types and now need to add the totals (11 of) columns, specific to aircraft type and mark. So I have a spreadsheet 25 cols wide with info (about 15,000 entries (each trip)) entered horizontally. Lets say I would like to identify one column (Aircraft type) and somewhere else summarize just that aircraft type? for example how do I get excel to recognise a name, ie Boeing and then get it total those columns in another cell. Hope that makes sense? I have tried to post the spreadsheet ont the site but to no avail. Any help gratefully accepted.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

stevenpengilly

Board Regular
Joined
Dec 17, 2004
Messages
52
Thank you so much I have tried that but it comes up with an error (using 2003 version) highlighting Boeing as the problem. Could you also try to explain the A:A B:B bit. Does the A:A refer to the input cell name and the B:B refer to output.

Sorry I am just a little bit confused by my own programme. The problem is that I can get a prog commercially but it would mean employing a typist for about 3 days "00000's" to enter in all the data. Its just not practicable. Again very many thank in anticipation.
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hope this makes it clearer:
Book1
ABCD
1
2Boeing26
3Focker2
4Focker2
5Boeing2
6Boeing2
7
8
9
10
11
Sheet7
 

stevenpengilly

Board Regular
Joined
Dec 17, 2004
Messages
52

ADVERTISEMENT

Thanks very much going to try it out later, how on earth do you get it to show answer utilising a spreadsheet. Regards
 

stevenpengilly

Board Regular
Joined
Dec 17, 2004
Messages
52

ADVERTISEMENT

Thank you very much it works a treat and now makes perfect sense. Again very many thanks Steve
 

stevenpengilly

Board Regular
Joined
Dec 17, 2004
Messages
52
Sorry but another one. Now got approx 30 worksheets all working well but now to link them together ie, totals from sheet 1 to beginning of sheet 2 and so on. Again very many thanks in anticipation.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,804
Messages
5,598,168
Members
414,215
Latest member
SRGDZMCS

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top