+ Reply to Thread
Results 1 to 3 of 3

MATCH, LOOKUP on other sheet, SUM findings

  1. #1
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Question MATCH, LOOKUP on other sheet, SUM findings

    Attached Sample File: Looking for a formula/function that will 'LOOKUP, MATCH if match found, SUM all the matches, then the data in x Column will be visible.

    Specifically, there's a COL P and COL Q on the REPORT tab (to show how many errors this line item had).
    The SUMMARY tab shows a roll up total of everything and the formula/function is needed on that SUMMARY tab (Cell B25).

    Cell B25 of SUMMARY should look at B1 of SUMMARY tab, then jump to the REPORT tab and LOOK through A:A for a MATCH...
    If it finds a row = to 6/14 (B25 of SUMMARY), THEN show the total count of P:P that are MATCHES = to the June 14th date of (B25 SUMMARY)

    The formula result in B25 of the SUMMARY tab should be 4.

  2. #2
    Forum Contributor
    Join Date
    03-27-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    154

    Re: MATCH, LOOKUP on other sheet, SUM findings

    Hi,

    =SUMIF(REPORT!$A2:$A100,B$1,REPORT!$P$2:$P$100)

  3. #3
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Re: MATCH, LOOKUP on other sheet, SUM findings

    Works like a charm! AWESOME!! Thanks so much!

+ 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