SUBTOTAL SUM AND AVERAGE
 

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,

SUBTOTAL SUM AND AVERAGE
 

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

"Souris" skrev i en meddelelse
...
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,

SUBTOTAL SUM AND AVERAGE
 

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,


"Per Jessen" wrote:

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

"Souris" skrev i en meddelelse
...
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,