View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Elena Elena is offline
external usenet poster
 
Posts: 43
Default AVERAGE() of subtotals

Hello James!

it is not a question of velocity :)))
The situation is more complicated.
We have to calculate percentage of fullfillment of each contract which in
tuern consists of different number of deliveries which also have different
percentage of fullfillment.
It looks like that:

Deliveries Contract
36% a
24% a
50% b
109% b
88% b
22% b
15% c
60% c

Based on this data we have to calculate an average percentage of
fullfillment for each contract. 109% means we have been better than contract
terms.
It has to be a chart grouped by contracts with indication of total average
so it is not clear whether we shall use an average throughout all range of
data or an average of averages for contracts - these figures are very
different.

Elena