| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
using COUNTA on a field that has been filtered
HELP
What is the function to count entries on a column that has been filtered. COUNTA will still count the hidden fields, rather than just the shown fields |
|
#2
|
|||
|
|||
|
Take a look at the SUBTOTAL function in help.
=SUBTOTAL(3,"your range")) John " wrote in message ... HELP What is the function to count entries on a column that has been filtered. COUNTA will still count the hidden fields, rather than just the shown fields |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
| I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) | |||
| Pivot Tables..I give up... | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Linear Mode
