Here's one simple way to set it up to cumulate in Sheet2 using SUMIF
In Sheet1,
The aircraft #s would be listed in A1 down
The hours-flown in B1 down
So it'll be logged in cols A & B as, e.g.:
1 2
3 2
1 3
2 5
2 3
3 4
etc
(Aircraft numbers would be repeated down in col A)
In Sheet2,
Aircraft #s (unique) are listed in A1 down,
Aircraft names listed in B1 down,
Accumulated hours to be computed in C1 down
Put in C1: =SUMIF(Sheet1!A:A,A1,Sheet1!B:B)
Copy C1 down
Col C will return the required cumulative figures
for the corresponding aircraft #s from Sheet1
Should you have an "initial" log in Sheet2 which needs to be "integrated",
just transfer/include this log into Sheet1 by copying and pasting over
Sheet2's cols A & C into Sheet1's cols A & B. Then continue the "new"
logging of the aircraft #s & hours-flown in the lines below.
And for a cleaner look in Sheet2,
we could suppress the display of zeros via, in Sheet2:
Click Tools Options View tab Uncheck "Zero Values" OK
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"garry05" wrote in message
...
Hi all...a newbie here.
I'm okay with many Excel functions, but I don't go too deep: Can't do
macros, lookups, that sort of thing.
Here's my dilemma: Sheet-2 has a list of 10 aircraft, and the goal is
to accumulate the hours-flown for each aircraft. Sheet-2 Column A is
the aircraft# (1-10), B is the aircraft name, C is the accumulated
hours-flown. Keeping it simple, let's say that A1=1, B1=Cessna, and
C1=26.5
Now, back to Sheet-1: Someone flew the Cessna for 2 hours...in A1 I'll
enter 1 for the aircraft#, and in B1 I'll enter "2" for the hours-flown.
Now Sheet-2 C1=28.5, or maybe some cell on Sheet-1, for all I care.
I can, of course, just go to Sheet 2, find the right column/cell and
update manually, but this is duplicated effort that leaves _way_ too
much room for human eror.
If anyone can help with this, it would be much appreciated...let me
know if you want a copy of the existing spreadsheet.
Thanks,
Garry )
--
garry05