Code for Subtotalling?

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

Has anyone any code for subtotalling the same as the built in facility
EXCEPT not to subtotal where there is only one line of data? Also on true
subtotal lines it would be useful to sum some columns, average others and
count others but perhaps I am getting too complicated!
 
Take a look at the pivot table options in Excel, you can specify the
grouping variables (for sub totalling) and the sumary statistics you
require. Far better than writing VBA code to do it.

Cheers
Nigel
 
You must log in or register to reply here.

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

Help! Subtotal using formulas or VBA 5
Subtotalling 1
Subtotalling 2
subtotalling - # of columns vary 1
Filters and subtotals 2
Data Subtotals Working Incorrecly 0
loop VBA request 1
Out of memory. Why? 4

Back
Top