Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
I am using excel 2007. In a worksheet I have values ranging fron D9 to
D1143. They are divided into 34 subsections. at the end of each section I use the formula =subtotal(9,start cell number.end cell number). I get the subtotals correct. I then highlight the entire range from D9 up to the line below the last subtotal which is cell D1144 and click on the sum icon to get the grand total of all the subtotals but no figure is showing up in the cell at all, it remains blank. I use subtotals in a number of my spreadsheets before and had no trouble but none extended to cells as far down as 1143. Is there a possible bug in the system? Please for any suggestions |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Try just clicking in cell D1145 and press Alt/=
or type =Subtotal(9,D9:D1144) "Rawle" wrote: I am using excel 2007. In a worksheet I have values ranging fron D9 to D1143. They are divided into 34 subsections. at the end of each section I use the formula =subtotal(9,start cell number.end cell number). I get the subtotals correct. I then highlight the entire range from D9 up to the line below the last subtotal which is cell D1144 and click on the sum icon to get the grand total of all the subtotals but no figure is showing up in the cell at all, it remains blank. I use subtotals in a number of my spreadsheets before and had no trouble but none extended to cells as far down as 1143. Is there a possible bug in the system? Please for any suggestions |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Thanks Bob, that formula worked.
"Bob Umlas, Excel MVP" wrote: Try just clicking in cell D1145 and press Alt/= or type =Subtotal(9,D9:D1144) "Rawle" wrote: I am using excel 2007. In a worksheet I have values ranging fron D9 to D1143. They are divided into 34 subsections. at the end of each section I use the formula =subtotal(9,start cell number.end cell number). I get the subtotals correct. I then highlight the entire range from D9 up to the line below the last subtotal which is cell D1144 and click on the sum icon to get the grand total of all the subtotals but no figure is showing up in the cell at all, it remains blank. I use subtotals in a number of my spreadsheets before and had no trouble but none extended to cells as far down as 1143. Is there a possible bug in the system? Please for any suggestions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |