| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding totals in columns
I have a worksheet that we have hidden rows in. I want to find the sum of a
column without picking up the hidden row values? I can I get a sum without including the hidden cell values? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding totals in columns
What version of Excel are you using?
If you're using Excel 2003 or later try this: =SUBTOTAL(109,A1:A10) -- Biff Microsoft Excel MVP "Tanya" wrote in message ... I have a worksheet that we have hidden rows in. I want to find the sum of a column without picking up the hidden row values? I can I get a sum without including the hidden cell values? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding totals in columns
Hi,
=SUBTOTAL(109,A1:A6) change range to fit your needs "Tanya" wrote: I have a worksheet that we have hidden rows in. I want to find the sum of a column without picking up the hidden row values? I can I get a sum without including the hidden cell values? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting and adding totals | Excel Worksheet Functions | |||
| Don't show repeated totals when not adding | Excel Discussion (Misc queries) | |||
| Adding totals to new sheet | Excel Worksheet Functions | |||
| Adding totals after filtering | Excel Discussion (Misc queries) | |||
| Adding category totals | Excel Worksheet Functions | |||
Hybrid Mode
