Hi All,

i want to map some data (count data) from one excel sheet to another like exactly how 'sumifs' function works.

SUMIFS = sum_range, criteria_range1, creiteria1

i want = count_range, creiteria_range1, creiteria1

Please help.