| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
only count designated rows
I have a spreadsheet that I have hidden some rows because of the size. I
would like to only get the sum of the rows that are not hidden. It seems when I do the sum function it is counting all the rows including the hidden rows. Please advise, thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only count designated rows
Have a look in the help index for SUBTOTAL
-- Don Guillett Microsoft MVP Excel SalesAid Software "Gerald" wrote in message ... I have a spreadsheet that I have hidden some rows because of the size. I would like to only get the sum of the rows that are not hidden. It seems when I do the sum function it is counting all the rows including the hidden rows. Please advise, thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only count designated rows
Hi,
Try this =SUBTOTAL(109,A1:A10) Mike "Gerald" wrote: I have a spreadsheet that I have hidden some rows because of the size. I would like to only get the sum of the rows that are not hidden. It seems when I do the sum function it is counting all the rows including the hidden rows. Please advise, thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only count designated rows
If you have a field that always has data in it, you could use this in a
different cell: =subtotal(3,a2:a9999) =Subtotal() won't count rows hidden by that autofilter. -kc "Gerald" wrote: I have a spreadsheet that I have hidden some rows because of the size. I would like to only get the sum of the rows that are not hidden. It seems when I do the sum function it is counting all the rows including the hidden rows. Please advise, thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a value next to a designated cell | Excel Discussion (Misc queries) | |||
| How to substitute whole word with different designated letters? | Excel Worksheet Functions | |||
| No printing of b/w designated cell patterns | Excel Discussion (Misc queries) | |||
| Fitting text in designated columns/rows | Excel Discussion (Misc queries) | |||
| Count designated cells | Excel Worksheet Functions | |||
Linear Mode
