SUBTOTAL SUM AND AVERAGE

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I have subtotal sum and average on the same data range.

The average and sum show on the different row.

Is it possible to have them on the same row on the spreadsheet?


Your information is great appreciated,
 
No problem, just make sure that you are using absolute references in your
formula, then copy /cut the formula to the desired cell.

Regards,

Per
 
Do you mean that put a dollar sign in front of the references cell like $C$1?
There are many of them so I need copy and paste every single one?
Are there any easier way to do this?

Thanks again,
 

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

Calculating subtotals 22
how to copy and paste "averages" 3
Average of Subtotals in Pivot Table 0
Autofilter and subtotal 1
using both sum and average in subtotals 2
loop VBA request 1
Copying just the summarized data 1
Sub-total questions 5

Back
Top