Subtotals and sum of subtotals

R

Rawle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top