SumProduct to add different worksheets?

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:

Please Login or Register  to view this content.

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.