Forum Discussion
dgearing
Jan 02, 2024Copper Contributor
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
dgearing
Jan 02, 2024Copper Contributor
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!
SergeiBaklan
Jan 02, 2024Diamond Contributor
- dgearingJan 03, 2024Copper Contributor
ā
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
- SergeiBaklanJan 03, 2024Diamond Contributor
And what is exact formulae in your Proj Labour and Actual Labour columns?
- dgearingJan 03, 2024Copper Contributor
That's where I want it updating