| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I subtotal then average the subtotals | Excel Discussion (Misc queries) | |||
| Average of Pivot Subtotal | Excel Discussion (Misc queries) | |||
| How to average subtotal cells in a column with other data | Excel Discussion (Misc queries) | |||
| Weighted Average Within Sort/Subtotal | Excel Discussion (Misc queries) | |||
| SUBTOTAL function to average column without blanks | Excel Worksheet Functions | |||
Linear Mode
