Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUBTOTAL vs FREQUENCY!?
Hi,
"Subtotal" has some functions that can be used in calculating subtotals within a list. However, unfortunately FREQUENCY is not one of the functions that can be used with SUBTOTAL! I am using a formula like this: SUM(N(FREQUENCY(A2:A46,A2:A46)0)) but when I hide some rows the formula still include the hidden ones in the calculations. Any way or alternative to overcome this? Thanks, Jo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |