+ Reply to Thread
Results 1 to 2 of 2

SumProduct to add different worksheets?

  1. #1
    Forum Contributor
    Join Date
    05-01-2006
    Location
    Erie, Pa USA
    MS-Off Ver
    Vista - Excel 2003
    Posts
    132

    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.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: SumProduct to add different worksheets?

    Quote Originally Posted by HBF
    Note: the person in A7 is listed in M3 in all of the monthly worksheets.
    If that is the case:

    Please Login or Register  to view this content.
    (incidentally you can not use SUMPRODUCT in 3D fashion - see: http://www.mcgimpsey.com/excel/threedsumif.html for more info but to reiterate I don't think you need it here given the above assertion)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1