| 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? |
| 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) | |||
Threaded Mode
