Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
tried using SUBTOTAL function (XL XP) and it doesn't seem to work
=SUBTOTAL(9,A1:A10) still gives total of rows 1 thru 10 even though i've hidden rows 5 thru 7 ??? is there any other method of working with visible cells only? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotal function with Filtered Data | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
subtotal - pivot table - or better function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions |