Need help with Excel ASAP

[The Pentium Guy]

Here's the deal.

I have an excel file with 4 names, followed by a number. (In case you're wondering, this represents the number of hours a person worked per quarter)


Name Total
Joe 111
Jack 333
Dan 222
James 542


In a single excel file there are 4 sheets that have this format. On a new sheet I'm trying to sum up the total that everyone has worked that particular year.

The only way I know how to do it is if the each name corresponds to a row number, then I can sum up the totals easily.

Now the only problem is, the names are out of order. Sorting them alphabetically isn't an option becuase there could be new names on each spreadsheet.

Basically what I'm trying to do is on the last page, given a name, it should look in the first four pages for that name, if it finds it, it'll grab that total and sum em up.

In other words:
http://img143.imageshack.us/img143/2455/untitledgh6.jpg

Thanks for the help
-The Pentium Guy

 

[Wizkid]

Use Match and Offset

Match will return the row # of the name, and offset will grab the value given a starting position and the row#.

=Match(A6,Sheet!$A:$A)

This will return the row # for each name on the summary sheet.

 

[Pepsi90919]

do your own homework

 

[Ramma2]

Why not sort the first 4 sheets so the names are in the same order?

 

[The Pentium Guy]

Originally posted by: Wizkid
Use Match and Offset

Match will return the row # of the name, and offset will grab the value given a starting position and the row#.

=Match(A6,Sheet!$A:$A)

This will return the row # for each name on the summary sheet.

Thanks a lot - I appreciate it.

Why not sort the first 4 sheets so the names are in the same order?

4 was just an example, what if there were many people (100+) on the list, leaving and joining, etc.

 

[Ramma2]

Originally posted by: The Pentium Guy

Originally posted by: Wizkid
Use Match and Offset

Match will return the row # of the name, and offset will grab the value given a starting position and the row#.

=Match(A6,Sheet!$A:$A)

This will return the row # for each name on the summary sheet.

Thanks a lot - I appreciate it.

Why not sort the first 4 sheets so the names are in the same order?

4 was just an example, what if there were many people (100+) on the list, leaving and joining, etc.

Delete the ones that don't show up on all 4 sheets.