//autoaverage.

[sansk_23]

Hi !! If i have a table like below :
WEEKS EAST NORTH SOUTH WEST COUNTRY

WK31 10 17 24 31 82
WK32 16 23 30 37 106
WK32 22 29 36 43 130
WK32 28 35 42 49 154
WK32 34 41 48 55 178
WK32 40 47 54 61 202
WK32 46 53 60 67 226
WK32 52 59 66 73 250
WK33 58 65 72 79 274
WK33 64 71 78 85 298
WK33 70 77 84 91 322
WK33 76 83 90 97 346
WK33 82 89 96 103 370
WK33 88 95 102 109 394
WK33 94 101 108 115 418
WK34 100 107 114 121 442
WK34 106 113 120 127 466
WK34 112 119 126 133 490
WK34 118 125 132 139 514
WK34 124 131 138 145 538
WK34 130 137 144 151 562

how can i get the region wise average for each week , automatically rather
than selecting the cells manually and giving the formula average() for each
week/region.

WEEKS EAST NORTH SOUTH WEST COUNTRY
Wk31
Wk32
Wk33
Wk34
Wk35
Is there any method like SUMIF() , for calculating the averages .... ??

rgds
Sk.

 

[Pete_UK]

Yes, try SUMIF divided by COUNTIF.

Hope this helps.

Pete

 

[bpeltzer]

How about Data > Subtotals? At each change in 'Weeks', show the Average of
East, North, South, West and Country.
If you need to have the results in a separate table, I'd go with a pivot
table. Double-click where it shows 'SumOf xxxxx' and change to shown the
Average.