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

try subtotal function

=SUBTOTAL(2,F3:F545)

On Dec 7, 1:41*pm, "George Gee" wrote:
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

Thanks for that, but that just counts the number of rows
that contain 0 or 1, when the list is unfiltered or filtered.

I want to display in F2 the number of 1's when filtered on 0,
which should of course be 0

George Gee


"muddan madhu" wrote in message
...
try subtotal function

=SUBTOTAL(2,F3:F545)

On Dec 7, 1:41 pm, "George Gee" wrote:
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

OK, this works: =SUBTOTAL(9,F3:F545)

Thanks
George Gee


"muddan madhu" wrote in message
...
try subtotal function

=SUBTOTAL(2,F3:F545)

On Dec 7, 1:41 pm, "George Gee" wrote:
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