Forum Discussion
AVERAGE won't populate until all cells have data
I need the average to populate as a running average and not only when all data has been inputted from different cells
Perhaps you may explain on concrete sample.
In general, AVERAGE() ignores blank cells, thus cells with no data won't affect the result.
If to ignore zeroes you may use AVERAGEIF().
Or that's something else?
SergeiBaklan When I put in AVERAGEIF it just says there are too many arguments for this function.
I have multiple cells to track weekly performance that go on another tab of a spreadsheet, I need these to have a running average when currently just says 'DIV/0!
Th 2nd one I want to update daily, theres 14 bits of data for each day but it won't update until all cells have data inputted
And what is exact formulae in your Proj Labour and Actual Labour columns?