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.

Yes, try SUMIF divided by COUNTIF.

Hope this helps.

Pete

On Aug 25, 9:24*am, sansk_23 <sans...@discussions.microsoft.com>
wrote:
> 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.

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.

"sansk_23" wrote:

> 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.
>