Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
summarize
I have a question. I have a column with only the figure 1, but many. Some are
hidden (invisible) and some are not. What I want to do is to summurize the figures that you can see on the screen, and note the hidden ones. So lets say I have 4 figures that are not hidden and 2 which is. In total a have 6 figures but I only wish to have the sum for the 4 figures that are not hidden. Beacuse all figures are 1, the sum should be 4 and not 6. How can I solve this? Can you help me? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
summarize
How are they hidden? Is the data filtered, conditionally formatted, rows
hidden, or what? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "PBark" wrote in message ... I have a question. I have a column with only the figure 1, but many. Some are hidden (invisible) and some are not. What I want to do is to summurize the figures that you can see on the screen, and note the hidden ones. So lets say I have 4 figures that are not hidden and 2 which is. In total a have 6 figures but I only wish to have the sum for the 4 figures that are not hidden. Beacuse all figures are 1, the sum should be 4 and not 6. How can I solve this? Can you help me? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
summarize
If your values are hidden by virtue of being filtered, then this will work....
=SUBTOTAL(9,A:A) Vaya con Dios, Chuck, CABGx3 "PBark" wrote: I have a question. I have a column with only the figure 1, but many. Some are hidden (invisible) and some are not. What I want to do is to summurize the figures that you can see on the screen, and note the hidden ones. So lets say I have 4 figures that are not hidden and 2 which is. In total a have 6 figures but I only wish to have the sum for the 4 figures that are not hidden. Beacuse all figures are 1, the sum should be 4 and not 6. How can I solve this? Can you help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
Summarize Out of Stock List | Excel Worksheet Functions | |||
how to summarize and chart raw data | Charts and Charting in Excel | |||
Summarize by cell format? | Excel Worksheet Functions | |||
How to summarize data based on specific parameters | Excel Discussion (Misc queries) |