Hi Excel forum,
I tried putting together the following code to countif only the visable cells if the following criteria is in the cells "P" "EL1" "EL2" & "EL3"
Please see codeBut i get 0 unless P is in the column.=SUMPRODUCT(SUBTOTAL(3,OFFSET(J2:J30,ROW(J2:J30)-MIN(ROW(J2:J30)),,1)),ISNUMBER(SEARCH({"P";"EL1";"EL2";"EL3"},J2:J30))+0)
Please see attached workbook with outlined result.
Thanks
Jamidd
Bookmarks