• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Feb 232011

Of late I’ve been doing a lot of slicing and dicing in Excel of IIS logs.  I end up fiiltering, sorting and all sorts..  but what I couldn’t fathom out is when I’d filtered my results how many of them I’d got.  A simple COUNT on the number of rows always returned however many rows were in the entire spreadsheet.. and that’s not what I want.

I found that you have to do :-

=SUBTOTAL (2,A1:A250000)

Bingo, it’s the right results !

Refence : http://excel.tips.net/Pages/T003831_Counting_Filtered_Rows.html

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>