Hello,

I am calculating average for unique values within the same column but it is returning 0. The uniques values are in column H and i am calculating average for the values in column R. What is wrong with the formula below. Please help.

=AVERAGE(IF(('Waseel Data'!H:H="Dental")*('Waseel Data'!H:H="Optical"),'Waseel Data'!R:R))