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
I was looking for a similar solution recently and the Subtotal formula worked great! Later, a colleague with minimal IT skills smiled as he showed me an alternate solution which is already there for users but probably hidden. At bottom of window, right-click on the taskbar (labelled 'Ready') and you get a variety of hidden options: just turn 'Count' on. Now when you highlight the rows to be counted, filtered or otherwise, you will see a count figure for those that are displayed - QED! In Excel 2010 you can turn on a number of thes hidden options at the same time if you wish - why not? I'm sure this will help people into the future so make the most of it!