Count Autofilter

carddard

Active Member
Joined
Aug 19, 2008
Messages
427
Hi guys,

How do I count the total number of rows for EVERY autofilter criteria in a column?

Meaning, say I have "Example 1", "Example 2" and "Example 3" in column A.
I want to display the total number of each of them. How do I do that?

Thanks!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Hi guys,

How do I count the total number of rows for EVERY autofilter criteria in a column?

Meaning, say I have "Example 1", "Example 2" and "Example 3" in column A.
I want to display the total number of each of them. How do I do that?

Thanks!

Not very clear...

Are you saying that you apply filter on, say, column B and you want to count the occurrences of the string "Example 1", say, in column C?
 
Upvote 0
Nope. Simpler than that. Everything happens in one column.
Well... Let me put it in another way..
I have some dates in column H. I don't know how many dates there are.

I need to count the occurences of every date that is in the column.

Is that better?
 
Upvote 0
Nope. Simpler than that. Everything happens in one column.
Well... Let me put it in another way..
I have some dates in column H. I don't know how many dates there are.

I need to count the occurences of every date that is in the column.

Is that better?

For dates...

=SUBTOTAL(2,Range)

For text, dates, etc...

=SUBTOTAL(3,Range)
 
Upvote 0
I am aware of the subtotal function, but I don't need the total number of ALL the dates.
I need the total number of EVERY date there is... Do you know what I mean?
 
Upvote 0
Hmm.. That wasn't what I wanted. =/
You see, the problem is, I need to know the count of EVERY date in the column.
If there are say "13/7/09", "14/7/09", "15/7/09", I need to know how many 13/7 there are, and how many 14/7 there are, and how many 15/7 there.

The problem is I dunno what kind of dates I'll be faced with, so I can't specify the dates. They are dynamic..
 
Upvote 0
Hmm.. That wasn't what I wanted. =/
You see, the problem is, I need to know the count of EVERY date in the column.
If there are say "13/7/09", "14/7/09", "15/7/09", I need to know how many 13/7 there are, and how many 14/7 there are, and how many 15/7 there.

The problem is I dunno what kind of dates I'll be faced with, so I can't specify the dates. They are dynamic..

Some options...

(1) Apply Advanced Filter to the range of interest with the Unique records only option checked, then run a COUNTIF formula with each date as criterion.

(2) Run Data|PivotTable... on the range of interest...
 
Upvote 0
Hmm. I've give those a try.

When I autofilter column H, is there a way to display the list of dates that are present, though?
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top