Add a Subtotal Row to an Existing Table?

J

Josh Doten

How do I add the subtotal row to an existing table without "manually
entering" the formulas?
 
D

Dave Peterson

I'd sort the data by my key field(s).

Then apply Data|subtotals (in xl2003 menus).
 
T

Toothsome Papa

You could enter the formula once, then copy it across the row, is that what
you mean?
 

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