S sachar Member May 5, 2015 #1 Dear All, With reference to the attachment, please, how get the numbers of "LV" for "B" employee with the help of countif formula? Attachments COUNTIF FORMULA_SAMPLE FILE.xlsx COUNTIF FORMULA_SAMPLE FILE.xlsx 9.3 KB · Views: 2
Dear All, With reference to the attachment, please, how get the numbers of "LV" for "B" employee with the help of countif formula?
Luke M Excel Ninja Staff member May 5, 2015 #2 Try this: =SUMPRODUCT(($A$2:$A$4="B")*($B$2:$F$4="LV")) or =COUNTIF(INDEX(B2:F4,MATCH("B",A2:A4,0),),"LV")
Try this: =SUMPRODUCT(($A$2:$A$4="B")*($B$2:$F$4="LV")) or =COUNTIF(INDEX(B2:F4,MATCH("B",A2:A4,0),),"LV")
Syedali Active Member May 5, 2015 #3 sachar said: Dear All, With reference to the attachment, please, how get the numbers of "LV" for "B" employee with the help of countif formula? Click to expand... PFA Attachments COUNTIF FORMULA_SAMPLE FILE.xlsx COUNTIF FORMULA_SAMPLE FILE.xlsx 9 KB · Views: 2
sachar said: Dear All, With reference to the attachment, please, how get the numbers of "LV" for "B" employee with the help of countif formula? Click to expand... PFA
