Yes, try SUMIF divided by COUNTIF.

Hope this helps.

Pete

On Aug 25, 9:24*am, 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.