| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use a function for filtered data
I am trying to count items in a spreadsheet using the following formula
=SUM(IF(FREQUENCY(A3:A83,A3:A83)0,1)) when I filter the amount comes up the same--how can I incorporate the subtotal function in here to get a proper number. The data in the range is week numbers that correspond with activities performed each day. I need to filter how many of the weeks the activity is done. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| Count function in Auto-Filtered data | Excel Discussion (Misc queries) | |||
| COUNTIF Function on filtered data | Excel Discussion (Misc queries) | |||
| Using Count Function on Filtered List | Excel Discussion (Misc queries) | |||
| Subtotal function with Filtered Data | Excel Discussion (Misc queries) | |||
Threaded Mode
