AVERAGE won't populate until all cells have data

Question

I need the average to populate as a running average and not only when all data has been inputted from different cells

sergeibaklan · Answer

dgearing&nbsp;
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?

dgearing · Answer

SergeiBaklan&nbsp;When I put in AVERAGEIF it just says there are too many arguments for this function.&nbsp;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!

sergeibaklan · Answer

dgearing&nbsp;
Better with the sample, otherwise it's not clear what's wrong. Like this one

dgearing · Answer

&nbsp;Th 2nd one&nbsp; I want to update daily, theres 14 bits of data for each day but it won't update until all cells have data inputted&nbsp;

sergeibaklan · Answer

And what is exact formulae in your Proj Labour and Actual Labour columns?

Forum Discussion

AVERAGE won't populate until all cells have data

Share

Resources