Hi

Range F3:F545 contains 0 or 1

Formula in F2 =COUNTIF(F3:F545,"0")
this counts the number of 1's and works fine.

Is it possible to count the number of 1's in a filtered list.
So when filtered on the 0's, then F2 should display 0

Thanks

George Gee