Forum Discussion
Solved
Function Help
Hello, I am trying to put together a spreadsheet that allows me to compare members of our team. We work in different "Sub" teams as you will. Just because you work on one team, does not mean your...
For the average, I proposed
=IFERROR(AVERAGE(FILTER(INDIRECT("Sales["&$B3&"]"), ((Sales[[Team 1]:[Team 1]]=$H$2)+(Sales[[Team 2]:[Team 2]]=$H$2)+(Sales[[Team 3]:[Team 3]]=$H$2))*(Sales[[Year]:[Year]]=$H$3))), "")
This includes Team 1, Team 2 and Team 3.
You used
=IFERROR(AVERAGEIFS(Sales[Jan],Sales[[Year]:[Year]],$H$3,Sales[[Team 1]:[Team 1]],$H$2),"")
which only looks at Team 1.
I have attached the workbook with my formulas again.
I wish I could Just add the Excel Book for y'all. If anyone Is able to do tell me how to do that that would be greatly appreciated!
Tripp