Get Average in Subtotals

  • Thread starter Thread starter JUAN
  • Start date Start date
J

JUAN

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
 
Hi
not really sure but have a look at the worksheet function
SUBTOTAL
in the Excel help. This should do what you want
 
You must log in or register to reply here.

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

Subtotal Formatting 2
I need ONLY subtotals copied to a second sheet 4
labels for subtotals 1
Average of Subtotals in Pivot Table 0
Divide two numbers in data subtotal function 2
Slow subtotal and insert row 3
Issue with nested data subtotals 3
percent of row in subtotal range 1

Back
Top