Averaging numbers for different column names

[martynmordecai]

Hey,

i have a spreadsheet where i want to average my shift managers times for the week. So far i have created it so it shows me the daily time (As you can see below)

Now what i want to do is create another table which will show an average time for every shift managers individual time (cashier,present,serve,hold).

Eg

Name............Cashier...........present..........serve............. hold
Rachel...........22...................60................133...............190
Sarah...........14....................50................105...............171
Ryan............14....................19.................69................43
Martyn.........13.5..................58...............120................172

seemed simple to me. However i then remembered that the names would change places every shift, so i am not guaranteed that sarah would always be in cell B2 and B7

Thanks

 

[CWatts]

If you have excel 2007 or later, you could use the AVERAGEIF function.

 

[Michael M]

Maybe, as an example
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;"></td><td style=";">Name</td><td style=";">Cashier</td><td style=";">Present</td><td style=";">Serve</td><td style=";">Hold</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;"></td><td style=";">Sarah</td><td style="text-align: right;;">13</td><td style="text-align: right;;">39</td><td style="text-align: right;;">77</td><td style="text-align: right;;">143</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style=";">Martyn</td><td style="text-align: right;;">13</td><td style="text-align: right;;">41.3</td><td style="text-align: right;;">103.5</td><td style="text-align: right;;">155.2</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;"></td><td style=";">Rachel</td><td style="text-align: right;;">22.1</td><td style="text-align: right;;">60.1</td><td style="text-align: right;;">133.3</td><td style="text-align: right;;">190.5</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Daily average</td><td style="text-align: right;;"></td><td style="text-align: right;;">16.0</td><td style="text-align: right;;">46.8</td><td style="text-align: right;;">104.6</td><td style="text-align: right;;">162.9</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;"></td><td style=";">Ryan</td><td style="text-align: right;;">14</td><td style="text-align: right;;">19.8</td><td style="text-align: right;;">69</td><td style="text-align: right;;">43</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style=";">Sarah</td><td style="text-align: right;;">15.5</td><td style="text-align: right;;">62.3</td><td style="text-align: right;;">133.5</td><td style="text-align: right;;">200.4</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Martyn</td><td style="text-align: right;;">14.4</td><td style="text-align: right;;">76.8</td><td style="text-align: right;;">138</td><td style="text-align: right;;">190.8</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Daily average</td><td style="text-align: right;;"></td><td style="text-align: right;;">14.6</td><td style="text-align: right;;">53.0</td><td style="text-align: right;;">113.5</td><td style="text-align: right;;">144.7</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style=";">Weekly Averages</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;"></td><td style=";">Sarah</td><td style="text-align: right;;">14.25</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;"></td><td style=";">Martyn</td><td style="text-align: right;;">13.7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;"></td><td style=";">Rachel</td><td style="text-align: right;;">22.1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;"></td><td style=";">Ryan</td><td style="text-align: right;;">14</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C5</th><td style="text-align:left">=AVERAGE(<font color="Blue">C2:C4</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D5</th><td style="text-align:left">=AVERAGE(<font color="Blue">D2:D4</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E5</th><td style="text-align:left">=AVERAGE(<font color="Blue">E2:E4</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F5</th><td style="text-align:left">=AVERAGE(<font color="Blue">F2:F4</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C9</th><td style="text-align:left">=AVERAGE(<font color="Blue">C6:C8</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D9</th><td style="text-align:left">=AVERAGE(<font color="Blue">D6:D8</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E9</th><td style="text-align:left">=AVERAGE(<font color="Blue">E6:E8</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F9</th><td style="text-align:left">=AVERAGE(<font color="Blue">F6:F8</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C12</th><td style="text-align:left">=SUMIF(<font color="Blue">$B$2:$B$9,"Sarah",$C$2:$C$9</font>)/COUNTIF(<font color="Blue">$B$2:$B$9,"Sarah"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C13</th><td style="text-align:left">=SUMIF(<font color="Blue">$B$2:$B$9,"Martyn",$C$2:$C$9</font>)/COUNTIF(<font color="Blue">$B$2:$B$9,"Martyn"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C14</th><td style="text-align:left">=SUMIF(<font color="Blue">$B$2:$B$9,"Rachel",$C$2:$C$9</font>)/COUNTIF(<font color="Blue">$B$2:$B$9,"Rachel"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C15</th><td style="text-align:left">=SUMIF(<font color="Blue">$B$2:$B$9,"Ryan",$C$2:$C$9</font>)/COUNTIF(<font color="Blue">$B$2:$B$9,"Ryan"</font>)</td></tr></tbody></table></td></tr></table><br />