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,
 
Back
Top