How to calculate average in a Word table and not include zeros?

Question

I have a MS Word table and need to calculate the average of a row without including any blanks or zeros?

Answer 1

Hi,

The formula feature of Word will automatically ignore blank cells, but not zero values. If you need to ignore zero values, you can manually remove or replace them before using the above formula.

Then you can go to Table Layout- Formula and enter the formula:

=AVERAGE(LEFT): Calculate the average of all cells to the left of the current cell.

=AVERAGE(RIGHT): Calculate the average of all cells on the right side of the current cell.

=AVERAGE(BELOW): Calculate the average of all cells below the current cell.

Hope the information is helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.