pilot flying logbook

[stevenpengilly]

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.

 

[fairwinds]

To link from sheet to sheet you would need to enter the formulas manually. However you could use a formula like
=SUM(Sheet1:Sheet30!A1)
To sum the same cell in several sheets.

 

[stevenpengilly]

Many thanks yet again. I was being a clown all I did was use the autosum and clicked the cells! works a real treat Regards