Thanks but that means I have to change the formula every time I change the filteri would normally use countif
1- Inspection Plan Log.xlsx
A B C 3 Row Labels Sum of Stk 4 Oil 1 0 4 5 Oil 2 1 6 Oil 3 0 7 Oil 4 2 8 Oil 5 14 9 Oil 6 0 10 Oil 7 5 11 Oil 8 0 12 Grand Total 22 Sheet2
Cell Formulas Range Formula C4 C4 =COUNTIF(B4:B11,">0")
=COUNTIF($B$4:$B$11,">0")