How do I add the subtotal row to an existing table without "manually entering" the formulas?
J Josh Doten Mar 16, 2010 #1 How do I add the subtotal row to an existing table without "manually entering" the formulas?
D Dave Peterson Mar 16, 2010 #2 I'd sort the data by my key field(s). Then apply Data|subtotals (in xl2003 menus).
T Toothsome Papa Mar 16, 2010 #3 You could enter the formula once, then copy it across the row, is that what you mean?