Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to use labels and 3-D references in a formala?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to use labels and 3-D references in a formala?
Excel User Brian wrote...
Is there a way to use 3-D referencing and labels in the same formula? . . . No. Labels with spaces between them are intersections of ranges, which are themselves ranges. 3D references are not ranges per se, so this is a syntactic restriction. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2003: Axis labels are truncated | Charts and Charting in Excel | |||
Pivot Table - 'Merge Labels' option and formatting | Excel Worksheet Functions | |||
XL Chart: Separately align series and value data labels | Charts and Charting in Excel | |||
Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
Alignment of Multiple-Level Category Labels Not Possible? | Charts and Charting in Excel |