If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
//autoaverage.
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. |
#2
|
|||
|
|||
//autoaverage.
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. |
#3
|
|||
|
|||
//autoaverage.
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. |
Thread Tools | |
Display Modes | |
|
|