Easy Mac
07-25-2006, 12:40 PM
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?
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?