Is there a way to use 3-D referencing and labels in the same formula? For
example, I would like to add up the total number of vacation days employees
at my company have taken throughout the year. My excel program has a
worksheet for each month (January to December) and a totals worksheet.
Within each worksheet are the names of the employees (cell location has to
change from time to time due to changes that occur in staffing) that are the
rows. Columns show the number of vacation, sick, family leave days, etc.
they have used.

I thought that a way to calculate the number of vacation days taken by "Bob"
would be =SUM(January:December!Vacation Bob).
I've also tried =SUM(January:December!Vacation Bob),
=SUM(January:December!"Vacation" "Bob"),
=SUM(January:December! Vacation Bob), and
=SUM(January:December!$Vacation Bob) as well as other variations.
But nothing worked (I got the ?Name or !NULL result each time)

Does anyone know anything that might work while using labels?

If not, is there another way that Excel can keep track of the right cells to
sum when the row numbers corresponding to each employee differ across the
monthly worksheets?

Any help you can give will be greatly appreciated.

Thank yoy,

Brian