using filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can somebody help me? I have several thousands lines of data. I use the
autofilter to organize data by product number, but I want to count how many
products of the same product numbers are there. I use the Count function, but
it doesn't work after the first section. For example, product number 2000 is
between cells A1234 to A2123, but when I run the count function with the
autofilter it automatically goes from A1 to A2123. It would take too long
for me to enter the range, IS THERE ANYWAY I CAN HIGHLIGHT A RANGE AND USE
THE COUNT AND AVERAGE FUNCTION WITHOUT MANUALLY ENTERING THE DATA
 
Lookup help on the SUBTOTAL funciton. It can be used to Count and Average
ranges while including or excluding filtered data. For example:

=SUBTOTAL(103,A1:2123)

This will provide a count of only the currently visible data within that
range.

HTH,
Elkar
 
You must log in or register to reply here.

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

Range referencing in VLOOKUP function, string concatenate? 4
Dynamic count on an Autofiltered list 3
Counting number of items excluding duplicates. 1
COUNTIF Function on filtered data 2
AutoSum on a filtered sheet 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to display sorted data? 2
Data Lookup Question 1

Back
Top