Hello,
In my workbook, I have 13 worksheets. One is a Year To Date, the rest are monthly, Jan-Dec.
On the YTD worksheet, I need a summary of all the months.
Column A lists the names of people (starting with A7), followed by Col B (total jobs assigned), col C (total jobs worked), and col D (total jobs not worked.
The information in the monthly worksheets is contained in cols M (names) starting with M3, O - (jobs assigned), P - (jobs worked), and Q - (not worked).
For the first attempt for the person in A7, I tried:
Note: the person in A7 is listed in M3 in all of the monthly worksheets.
The result of the above is #NUM!
Suggestions?
Posting the worksheet is not an option due to it's size.
Thanks in advance.
Bookmarks