TryFormula:
=COUNTIFS(Sheet1!$A$2:$A$16,A2,INDEX(Sheet1!$B$2:$N$16,,MATCH(B1,Sheet1!$B$1:$N$1,0)),"<>0")
TryFormula:
=COUNTIFS(Sheet1!$A$2:$A$16,A2,INDEX(Sheet1!$B$2:$N$16,,MATCH(B1,Sheet1!$B$1:$N$1,0)),"<>0")
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks