Hi
Id like to average hours worked every 5 days but need toexclude days where no hours have been worked. Was playing about with AverageIf to achieve this and wouldnt be aproblem for the formula in cell below (answer is 9.6). However, if I drag the formula along (Formula 2), the average will onlybe for 4 days as itll ignore the zero in the cell for Day 6. Is there a way of dynamically referencing theprevious 5 cells where hours have been worked?
Thanks
<tbody>
</tbody>
Id like to average hours worked every 5 days but need toexclude days where no hours have been worked. Was playing about with AverageIf to achieve this and wouldnt be aproblem for the formula in cell below (answer is 9.6). However, if I drag the formula along (Formula 2), the average will onlybe for 4 days as itll ignore the zero in the cell for Day 6. Is there a way of dynamically referencing theprevious 5 cells where hours have been worked?
Thanks
Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 |
8 | 8 | 8 | 12 | 12 | 0 | 0 | 8 | 8 | 8 |
9.6 | Formula 2 | Formula 3 | Formula 4 | Formula 5 | Formula 6 |
<tbody>
</tbody>