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

G

Guest

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!
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I 'count' the number of entrances in filtered cells? 2
How do I autosum a filtered column 1
Sum after Filter, Count after Fliter 2
Referncing Rows of Filtered Data 8
Calculate Filtered Cells Only 7
Sum of filtered data 3
Randomly Select cell from filtered list 1
Copying Filtered Data in Excel 2007 5

Top