 |
07-25-2006, 12:40 PM
|
#1 | ||
|
Registered User
Join Date: Nov 2001
Location: Here
|
Excel Question
OK, so I have a little idea on how to sum over multiple worksheets. However, this is what I want to do:
I have a list of people for each year in a worksheet (so I have a 99 worksheet, 00, 01...). The lists are sorted alphabetically and have other info associated with each person. How do I sum across worksheets so that I can find the totals for each person. Now normally I can just do the A!20 function or whatever to sum across worksheets, however, some people are in different spots in each worksheet or aren't in all of them. So is there a way to do it using a reference ID for each person to sum in a new blank worksheet? |
||
|
|
|
07-25-2006, 12:42 PM
|
#2 |
|
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
have you tried vlookups?
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
