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?