Subtotals

D

donallen

When we subtotal a spreadsheet based on a change in a paticular column, is
there a way to include all of the fields in the subtotal row?
For example, currently when we subtotal a spreadsheet consisting of Client
ID, Client Name; Division, Sales, Sales Rep based on a change in Client ID
and totaling Sales, the subtotal line looks like this
Client ID
Sales
We would like for all of the data to show on the subtotal line like this.
Client ID Client Name Division Sales Sales
Rep

Is there any way to accomplish this?

Thanks
Don
 
P

Peo Sjoblom

Look to the left, there should be plus sign(s), click it/them

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 

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

Similar Threads

Subtotalling 1
Additonal info into newly created Subtotal row 1
Subtotal Function - add formula to all blank rows 1
Subtotal 3
multiple subtotals 1
Count If 1
Finding a count above average 1
Ranking Sales Reps 2

Top