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,
Bookmarks