Formula to count filtered cell with "0"

[zeusdogo]

I have filtered cell based on color, each color represents different category. when worksheet will be used, it wont be filtered. I want to count cells in the coulmn "H" with the value "0". I have tried using countif but as soon as I remove filter formula will count all the cells with the value "0" and not the particular category. I appreciate all the help I can get


Thanks
​

 

[asma410]

try using SUMIF instead. Make a column next to "H" & fill it with '1'. Select a cell & add the formula for SumIf, for example:
=SUMIF(A2:A13,B1,B2:B13)

A2:A13 is my range
B1 is the condition (=0)
B2:B13 is the range with value 1