+ Reply to Thread
Results 1 to 2 of 2

Partial Sums of different tabs using the Index / Match formula

  1. #1
    Registered User
    Join Date
    12-01-2016
    Location
    Toronto, Canada
    MS-Off Ver
    Office 2016
    Posts
    3

    Partial Sums of different tabs using the Index / Match formula

    Hi guys, can anyone give me some help?
    I have a file attached for you to check it.
    There is a tab called WSIB in there. The column FROM JAN CONTRACTORS is getting values from the CP 06 Jan and CP 20 Jan. When the name of the employee is inputted in the name cell, it will look using the index/match formula for the same name in both of these tabs.
    What I want is this:
    - In the CP tabs, there is a column called "Include in the WSIB?" that offer to the user the choice of including that data of the employee in the Summary WSIB tab ; (I did it)
    - In the FROM JAN CONTRACTORS it will sum both the data from the CP tabs of the month ; (I did it)

    But what is happening is that it will only sum when the name of the employee is in BOTH of the CP tabs... I Want to have partial sums (if only one CP tab has the name of the employee it will give the partial sum).

    Can you guys help me on that?

    Thank You,
    Daniel Grossi
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Partial Sums of different tabs using the Index / Match formula

    here is a small modification to your formula. It includes an IFERROR function to return zero in the case a missing name creates a #N/A result.

    Please Login or Register  to view this content.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index Match with Partial Match in Lookup Array
    By AliGW in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2016, 03:13 PM
  2. INDEX / MATCH Formula Help - Partial Match
    By scoochUM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-25-2016, 10:56 AM
  3. Index array formula based on a partial date match
    By amygweber in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2016, 02:25 PM
  4. Index partial match?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2015, 02:12 PM
  5. finding partial text in an index match formula
    By garyaw in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-30-2015, 04:27 PM
  6. [SOLVED] INDEX MATCH Multiple Output with Partial Match
    By Ray Storm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2015, 12:05 AM
  7. Replies: 2
    Last Post: 09-27-2014, 04:34 PM

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