I need to create an average of the range below into the top box however due to the cells being both numbers and text it doesn't seem to let me use =AVERAGE()
Can anyone help me get the average of my range to show into the top box. See below for range and cells.
<tbody>
</tbody>Obviously the average is 3 here however i need to a formula to automatically do this for the whole column based on specific cells. If someone could help me with the first one i can set it up for the rest.
Can anyone help me get the average of my range to show into the top box. See below for range and cells.
H | ||
1 | (Formula to go here) | |
2 |
<tbody> </tbody> | |
3 |
<tbody> </tbody> | |
4 |
<tbody> </tbody> | |
5 |
<tbody> </tbody> | |
6 |
<tbody> </tbody> |
<tbody>
</tbody>