I have data on a worksheet through functions and macros, postions of data
changes all the time, no a specific range can be define, i am known to
subtotal function but for now its not enough

i have two major fields for my data
first is sector and and is company

Column A Column B
Sector Company

i need subtotal Average for every company (same co. could be on multiple
rows) but the grand total Average for sector (Because average result for the
whole data and average result of subtotal of companies are entirely
different) i have 34 different sectors and around 250 companies and have to
average on 15 columns

i have made the data available already sorted through sector and then
company and have 2 blanks rows after each company through function and macro

can anyone help if this could be done through any funtion or macro, it would
be really great
thanks