M m9vukyem Member Aug 6, 2021 #1 dear sir please guide me how to make formula when 2nd criteria range in row and criteria in column
M m9vukyem Member Aug 7, 2021 #3 please find attachement Attachments example.xlsx 236.9 KB · Views: 8
B bosco_yip Excel Ninja Aug 7, 2021 #4 Try, In V1, enter formula : =COUNTIFS(sal!A3:A353,sal!A2,INDEX(sal!H3:V353,0,MATCH(T1,sal!H3:V3,0)),">0")
Try, In V1, enter formula : =COUNTIFS(sal!A3:A353,sal!A2,INDEX(sal!H3:V353,0,MATCH(T1,sal!H3:V3,0)),">0")
