how do i count amount of data in a filtered list?
 

once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i
want to know if there is a way to count the amount of rows data there are
after i filter?? Thanks!

how do i count amount of data in a filtered list?
 

Assuming that your data is from A2:A1000
=SUBTOTAL(3,A2:A1000)
JTP wrote:
once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i
want to know if there is a way to count the amount of rows data there are
after i filter?? Thanks!

how do i count amount of data in a filtered list?
 

Have a look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JTP" wrote in message
...
once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been
filtered. i
want to know if there is a way to count the amount of rows data there are
after i filter?? Thanks!

how do i count amount of data in a filtered list?
 

i tried that, but my values are not numbers. when i am configuring hte
subtotals, i dont know if i shoukld use "count", "sum", "vald" etc to count
up text values...

"Don Guillett" wrote:

Have a look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JTP" wrote in message
...
once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been
filtered. i
want to know if there is a way to count the amount of rows data there are
after i filter?? Thanks!

how do i count amount of data in a filtered list?
 

=subtotal(3,range you want to count)

3 would be for countA
2 would be for count

"JTP" wrote:

i tried that, but my values are not numbers. when i am configuring hte
subtotals, i dont know if i shoukld use "count", "sum", "vald" etc to count
up text values...

"Don Guillett" wrote:

Have a look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JTP" wrote in message
...
once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been
filtered. i
want to know if there is a way to count the amount of rows data there are
after i filter?? Thanks!