'Averageif with multiple or condition on multiple columns

I want to calculate the average rating of Dr.A, Dr.B and Dr.C for date 1/1/2021 to 1/3/2021.

I tried the formula-

=AVERAGE(AVERAGEIFS($F$3:$F$28,$D$3:$D$28,{"Dr. A","Dr. B","Dr. C"},$A$3:$A$28,{"01-01-2021","02-01-2021","03-01-2021"}))

But this gives me the average of average and not the average value.

Please help me with the solution for this.

excel average

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source