# Count Autofilter

#### carddard

##### Active Member
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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

##### MrExcel MVP
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?

#### carddard

##### Active Member
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?

##### MrExcel MVP
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)

#### carddard

##### Active Member
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?

##### MrExcel MVP
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?

No..., if not:

=COUNT(Range)

#### carddard

##### Active Member
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..

##### MrExcel MVP
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...

#### carddard

##### Active Member
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?

Replies
3
Views
204
Replies
1
Views
459
Replies
3
Views
246
Replies
1
Views
258
Replies
8
Views
180

1,191,690
Messages
5,988,104
Members
440,126
Latest member
duque00

### 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.

### Which adblocker are you using?

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

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