I have a PivotTable with 10 individuals and their scores every week in Sheet2 with a slicer to filter the average score of those who are with Team Red and Team Blue. I need a formula in Sheet 1 in B2 to get the average score of Team Red, B3 to get the average score of Team Blue and B4 to get the average score of all participants. Is this possible? 1 Team Score 2 Team Red 96% 3 Team Blue 96% 4 Total 96%

message edited by CuriousChris

If the pivot table looks always like in your example, meaning that in Sheet2 Team Red score is in B2, Team Blue in B3 and Total in B4, in Sheet1 you could write exactly that: B2=Sheet2!B2 B3=Sheet2!B3 B4=Sheet2!B4Or you could extract the percentages based on the source of the pivot table with a longer formula.

Ask Your Question

Weekly Poll

Are you looking forward to the Xbox Series X?

Discuss in The Lounge

Poll History