Jan 07 2022 07:00 AM
Jan 07 2022 08:32 AM
=COUNTA(UNIQUE(FILTER($A$2:$A$16,$C$2:$C$16=E13)))
=SUMIF($A$2:$A$16,E5,$B$2:$B$16)/COUNTIF($A$2:$A$16,E5)
Maybe with the above formulas as shown in the attached file. The first formula works if you use Excel online or Office365 or 2021.
Jan 07 2022 09:44 PM