count filtered rows

  1. L

    count filtered rows

    Hi, I filtered my table and need to count the "Y"s in a column. The formula I have is =COUNTIF(K2:K3480;"Y") but it doesnt update if I filter the table.
  2. B

    Counting "filtered rows"

    Hello out there, I'm trying to count the number of rows using =counta(a1:a2000), however it is also taking into account the hidden rows that have been filtered out. I cannot find a awy to produce the results. Thank you, Pete

Some videos you may like

This Week's Hot Topics