Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include only visible cells in a range?
I have a time sheet that contains a years worth of daily row entries. I hide
all rows except the current week which I am entering data into and printing as a record that contains Weekly and Yearly column totals for multiple column items. I am currently resetting the summed ranges for the week manually for each of the multiple column items, but would like to derive the ranges automatically by conditionally summing only the visible cells. Thanks, Paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include only visible cells in a range?
One way:
=SUBTOTAL(109,rng) In article , "Frequent User" wrote: I have a time sheet that contains a years worth of daily row entries. I hide all rows except the current week which I am entering data into and printing as a record that contains Weekly and Yearly column totals for multiple column items. I am currently resetting the summed ranges for the week manually for each of the multiple column items, but would like to derive the ranges automatically by conditionally summing only the visible cells. Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
Count occurances in range of cells | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |