Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal & Sum Question
Hi,
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. I tried this instead: SUBTOTAL(109, N ( FREQUENCY(A2:A46,A2:A46) 0 ) ) but got an error Any way or alternative to overcome this? Thanks, Jo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal question | Excel Worksheet Functions | |||
subtotal question | Excel Programming | |||
subtotal question? | Excel Worksheet Functions | |||
subtotal question | Excel Discussion (Misc queries) | |||
subtotal question | Excel Programming |