Countif within a filtered sheet
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
|