Hello,
I have the following formula in one of my cells:
=AVERAGEIF('Individual Player Raw Data'!B:B,$B66,'Individual Player Raw Data'!G:G)
It matches the B66 cell value on the current sheet with the same cell values on the B:B column on the 'Individual Player Raw Data' sheet.
On the rows that these match, it calculates the AVERAGE of the values in the G:G column on the 'Individual Player Raw Data'.
I now want to have another condition.
As well as above, I also want it to factor in the cells which the current sheet's A66 cell value matches with the A:A column on the 'Individual Player Raw Data'.
I'm not sure how to write this formula.
I hope I've explained this well.
Your help is HUGELY appreciated.
Bookmarks