Forum Discussion
Sum different qualifiers from separate sheets on a YTD sheet
I have 28 sheets for different two week pay periods for the whole year. Each person can have different lettered time off for the time pay period. I need to sum the different lettered types for each person and place on the YTD sheet.
Lucy_McMahon I figured but thought I read something about count... hours shown in attached
9 Replies
This is very do-able but the following are going to be needed before proceeding:
-version of Excel you're running
-a scaled down sample of your workbook
Version is very important because this task will likely involve 3D references.- The cell references aren't calculating accurately on this sample but they work on the full workbook. For this question, I just need to figure out how to sum the YTD total for each leave type for each person using a 3d reference across all sheets.
Dear Lucy, I'm afraid you have described your objective far too vaguely to contain a detailed answer. The codes in your screenshot cannot be understood by an outsider.
Your problem is probably best solved with the SUMIFS() function. Perhaps you can look at the help for this function and solve your problem on your own.
