Average of Salary using multiple criteria

[webmax]

Hi

I am attaching the data which contains master data in one sheet and in the output sheet if select the drop menu of the three criteria like Role, Region & Experience the Average CTC should come in the last column.

Regards
Shahul

 

[NARAYANK991]

Hi Shahul ,

See your file.

Narayan

 

[kchiba]

Hi Shahul,

see attached

 

[Syedali]

My try