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?

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