@ kishoremcp
See if this workbook helps, it uses Dynamic Named Ranges, so the SUMPRODUCT() formulae always calculate the exact ranges.
Add or subtract from your data list in Sheet "Raw Data", the ranges will adjust according to the last entry in Column L "Agent"
In Sheet "Agent" B2
Drag Across to Column H, Then Down=SUMPRODUCT((Region=$K$2)*(Agent=$A2)*(Contact_Type=$L$2)*(Satisfaction=B$1))
$K$2:$L$2 contains dropdowns, select as required.
Bookmarks