| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
SumIf in Visible Cell Range
In Excel 2003 you can summarize hidden rows by using another set of
keys for subtotal (X+100) - see Excel Help for Subtotal function. SUBTOTAL(9,D2:D7) = Summarize all (visible and invisible) rows SUBTOTAL(109,D2:D7) = Summarize visible rows only With the columns however this is not so simple. To know more see the topic: "Subtotal function for hidden row" topola - 13 Paz. 16:04 microsoft.public.excel.worksheet.functions Topola |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Hybrid Mode
