Using Subtotals tool to average multiple rows of non-continuous data based on ID #

B

bwlonge

When I used Subtotals tool, i get it to work almost all the way. I
detects the change in ID number in column A, but it will only averag
one column, depending on where I place the subtotal. I need it t
calculate the average across the columns AND rows for a single average
Any ideas? Want me to post an example
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotals every "X" number of rows 3
average of non contigous data to also exclude zeros 7
Calculating an average of data between two dates 1
Multiple subtotals on a single line 3
How to filter rows data based on background color of individual cells 3
sumproduct to calculate total based on non-continuous columns? 1
Adding columns w/new formulas BUT keeping subtotals 0
Basing Average function range on Date? 4

Top