Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Count
How do I get a record count afer I filter a column in Excel? Example: I have
a list of 100 names and I filter out those who prefer phone contact versus e-mail countact. How do I get a count (a number) without manually counting each record that appears after the filter? Thank you, Frances |
#2
|
|||
|
|||
Frances, have a look at subtotals in help, something like this should work,
=SUBTOTAL(3,A2:A20) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "fran55" wrote in message ... How do I get a record count afer I filter a column in Excel? Example: I have a list of 100 names and I filter out those who prefer phone contact versus e-mail countact. How do I get a count (a number) without manually counting each record that appears after the filter? Thank you, Frances |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |