Results 1 to 7 of 7

Multiplying COUNTIFS using a VLOOKUP table rather than making lots of COUNTIFS

Threaded View

  1. #1
    Registered User
    Join Date
    09-04-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    24

    Multiplying COUNTIFS using a VLOOKUP table rather than making lots of COUNTIFS

    I've made this basic spreadsheet attached. In the ‘Workers’ sheet it COUNTIFS every time that worker’s name appears in the ‘Session’ column of the ‘Data’ spreadsheet, takes the ‘Score’ and using the info in the ‘Table’ spreadsheet gives a ‘Total Cost’ figure of every session associated with that worker.

    What I want to know is, is there a way of doing this same calculation without having to write out a new ‘+COUNTIFS’ function for every single ‘Score’ to ‘Cost’ calculation, as you can see I’ve done in Workers!B2 and down. I’ve been trying to turn it into a VLOOKUP formula to simplify/shorten it but haven’t been able to work out how to do that.

    Thanks,
    Attached Files Attached Files
    Last edited by DIAL90; 03-19-2019 at 03:48 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Making a pivot table with lots of data
    By meganed5 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2017, 12:44 PM
  2. [SOLVED] Sumproduct to replace countifs as countifs don't work on external source reference
    By KrishnaSagar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2017, 02:33 AM
  3. How can I run CountIfs + CountIfs without double counting?
    By hiitsjessie in forum Excel General
    Replies: 1
    Last Post: 02-06-2017, 04:49 PM
  4. Making CountIFS and SUMIFS Formula Dynamic
    By HangMan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2015, 04:58 AM
  5. COUNTIFS OR...multiple countifs without duplication in the numbers
    By HooligaD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 09:53 AM
  6. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  7. Making countifs reference inequalities
    By mremmenga in forum Excel General
    Replies: 1
    Last Post: 10-22-2008, 05:42 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