Averaging with SUMPRODUCT

[3345james]

Got a great formula from daffodil11 that solved the challenge of multiple data files and pulled references from cells generated by a slicer.
Using this same formula I need to generate an average of what the sum product found. There are 6 scores 95,95,95,95,100,100 for an average of 96.67 (Total SUMPROD = 580). I've tried a few variations of average; averageif; counta

=SUMPRODUCT((TEXT('Call Scores'!$B$2:$B$5002,"mmm")=S26)*('Call Scores'!$A$2:$A$5002=S9)*('Call Scores'!$C$2:$C$5002))

Appreciate the assist
Thanks
Jim

[Jonmo1]

Average = SUM divided by COUNT

So I assume you already have the SUM, provided by the formula you just posted.
Let's say that formula is in cell A1 just for example.

The COUNT would be
=SUMPRODUCT((TEXT('Call Scores'!$B$2:$B$5002,"mmm")=S26)*('Call Scores'!$A$2:$A$5002=S9))

So the Average would be
=A1/SUMPRODUCT((TEXT('Call Scores'!$B$2:$B$5002,"mmm")=S26)*('Call Scores'!$A$2:$A$5002=S9))

[3345james]

Thanks so much - works perfectly
I must be brain dead

[Jonmo1]

You're welcome