| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Subtotals tool to average multiple rows of non-continuous data based on ID #
When I used Subtotals tool, i get it to work almost all the way. It detects the change in ID number in column A, but it will only average one column, depending on where I place the subtotal. I need it to calculate the average across the columns AND rows for a single average. Any ideas? Want me to post an example?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Subtotals tool to average multiple rows of non-continuousdata based on ID #
yes
On Jan 30, 6:42*pm, bwlonge wrote: When I used Subtotals tool, i get it to work almost all the way. It detects the change in ID number in column A, but it will only average one column, depending on where I place the subtotal. I need it to calculate the average across the columns AND rows for a single average. Any ideas? Want me to post an example? -- bwlonge |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| need help please inserting multiple rows based on cell value then copying to data sheet | Excel Worksheet Functions | |||
| Multiple Selection of Non-Continuous Data | Excel Worksheet Functions | |||
| Can I select whole rows of non-continuous range data? | Excel Programming | |||
| Continuous conversion of data from rows to columns | Excel Programming | |||
Linear Mode
