DaveFranken
New Member
- Joined
- May 6, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I've been looking for a proper and efficient way to solve my problem, but I just can't figure it out.
I have a table with some results where each instance is on a seperate column and details are found on different rows in that column (for example which employees were present). See the image attached, result table on the left.
Out of this table, I need to know for each employee how often they appear and what their average score is by filling in the table on the right side.
Getting the count is easy, but I just can't seem to find an efficient way of calculating the average. I tried the sumif function, but that doesnt allow me to have multiple rows in my range.
How should I approach this?
Person A as example; in cell O4 i need a formula that uses M4 as criteria and look for that in range C6:G11. Then for every match, sum the value in row 5 (score) and then take the average of all instances.
Your support in this is much appreciated! Thnx!
I've been looking for a proper and efficient way to solve my problem, but I just can't figure it out.
I have a table with some results where each instance is on a seperate column and details are found on different rows in that column (for example which employees were present). See the image attached, result table on the left.
Out of this table, I need to know for each employee how often they appear and what their average score is by filling in the table on the right side.
Getting the count is easy, but I just can't seem to find an efficient way of calculating the average. I tried the sumif function, but that doesnt allow me to have multiple rows in my range.
How should I approach this?
Person A as example; in cell O4 i need a formula that uses M4 as criteria and look for that in range C6:G11. Then for every match, sum the value in row 5 (score) and then take the average of all instances.
Your support in this is much appreciated! Thnx!