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
|