When calculating Average using the function "=AVG(Below) in a Word Table column header, is there a way to make Word disregard any blank cells (such as entering some kind of 'null' value?) For example, in a one-column 14-day table, daily readings were not entered on six of the 14 days. If I leave those six cells blank, the =AVG(BELOW) function returns an average value of 92:


If I enter zeroes in all the empty cells, the =AVG(BELOW) function returns an average of 61:

But if I delete those six empty cells, the =AVG(BELOW) function returns an average value of 107. This is result I want, but I don't want to have to delete empty cells before updating the field.

the AVG(BELOW) function returns an average value of 92.AVG(BELOW