Countif visible
"Sean" escreveu:
I have a group of data with autofilters on headers I would like to count
occurances of numbers by using countif. When I select filtered criteria I
would like the values to change. I can't make this work with a pivot table
because of the structure of the data. Is there a countif visible formula
similar to a subtotal(9,AB1:AB23456)?
Thanks
=subtotal(2,ab1:ab23456)
the 2 is for count
take a look on subtotal help
hth
regards from Brazil
Marcelo
|