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.
https://1drv.ms/x/s!AsTpsZBaeWzBcIlEEnf2t5HsTZw?e=xbbpYV
Attached is the Link for the problem.
Attached is the Link for the problem.