View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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,