Need Count of data

[guru_charm]

Hello Excel Gurus,

Is there any formula to calculate the count of numbers which in filter. For an Example if a i filter any detail only that count should come in a prticular cell, when i change the filter to another data that count should come. If it can be done in macro also fine.
Please help me in this

 

[sanrv1f]

Try this

=SUBTOTAL(2,A1:A100)

 

[hiker95]

guru_charm,


See if this helps.


Sample data before setting the autofilter:

Excel Workbook
	A	B	C	D	E	F
1	A	B	C	D		5
2	A2	B2	100	D2
3	A3	B3	1	D3
4	A4	B4	100	D4
5	A5	B5	1	D5
6	A6	B6	100	D6
7
Sheet1

I we set the autofilter, and in column C, we pick 1, we get:

Excel Workbook
	A	B	C	D	E	F
1	A	B	C	D		2
3	A3	B3	1	D3
5	A5	B5	1	D5
7
Sheet1

The formula in cell F1

=SUBTOTAL(102,C:C)

the 102 means ignore hidden rows.