Counting after Filter

**jasonjhc** · 12-13-2013, 08:24 AM

Hi,

as the title suggests I'd like to apply a count to a sheet which adjusts when filtered. I have attached a sheet, but as you can see the filter is returning the incorrect count as it is including the rows which are not displyed

**alansidman** · 12-13-2013, 08:32 AM

Try using the countif function in column C

Data Range

	A	B	C	D	E
1	Task	Type
2	Task 1	Dev	Bug	6	=COUNTIF($B$2:$B$27,C2)
3	Task 2	Dev	Dev	20
4	Task 3	Dev
5	Task 4	Dev
6	Task 5	Dev
7	Task 6	Dev
8	Task 7	Bug
9	Task 8	Bug
10	Task 9	Bug
11	Task 10	Dev
12	Task 11	Dev
13	Task 12	Dev
14	Task 13	Dev
15	Task 14	Dev
16	Task 15	Dev
17	Task 16	Bug
18	Task 17	Dev
19	Task 18	Dev
20	Task 19	Bug
21	Task 20	Dev
22	Task 21	Bug
23	Task 22	Dev
24	Task 23	Dev
25	Task 24	Dev
26	Task 25	Dev
27	Task 26	Dev

**popipipo** · 12-13-2013, 10:50 AM

or use the subtotal function:
=SUBTOTAL(3,B8:B22)

Counting after Filter

LinkBack

Thread Tools

Rate This Thread

Display

Counting after Filter

Re: Counting after Filter

Re: Counting after Filter

Thread Information

Users Browsing this Thread

Similar Threads

Counting instances in a filter

unique counting + filter

counting number of results after filter

counting number of items after filter

Counting lines when using a filter

Bookmarks

Bookmarks

Posting Permissions