Get Average in Subtotals
 

Hello,
have a file with subtotals in columns D-J. I want to take
that subtotal and divide by the rows its getting the
total. So basically an average. Maybe do a search for the
word SUBTOTAL in the formula and then divide by the rows
and copy throug Column J.
My file can change so the subtotal migth beginng in D20 or
maybe in D25 and so forth. And my first subtotal might
have 18 rows second subtotal might have 4 rows. So need to
find a way to get the average of that subtotal.

Please advise if this can be done. Really appreciate any
help I can get.
Thank you,
juan

Get Average in Subtotals
 

Hi
not really sure but have a look at the worksheet function
SUBTOTAL
in the Excel help. This should do what you want

--
Regards
Frank Kabel
Frankfurt, Germany


JUAN wrote:
Hello,
have a file with subtotals in columns D-J. I want to take
that subtotal and divide by the rows its getting the
total. So basically an average. Maybe do a search for the
word SUBTOTAL in the formula and then divide by the rows
and copy throug Column J.
My file can change so the subtotal migth beginng in D20 or
maybe in D25 and so forth. And my first subtotal might
have 18 rows second subtotal might have 4 rows. So need to
find a way to get the average of that subtotal.

Please advise if this can be done. Really appreciate any
help I can get.
Thank you,
juan