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

This is addressed in my Microsoft Word Field Maths Tutorial. See the corresponding 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/word/...-tutorial.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]