Calculate average in a column, but ignore empty cells?

		Microsoft Office Forums > Microsoft Word > Word
Calculate average in a column, but ignore empty cells?

08-09-2022, 07:46 PM

macropod

Windows 10 Calculate average in a column, but ignore empty cells?

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,384

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]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to calculate average of a ratio from a column?	Bumba	Excel	2	01-15-2020 05:53 AM
Calculate average age (years)	lyiio	Excel	3	08-13-2017 12:12 AM
how to calculate average time	aymanharake	Excel	6	02-17-2017 04:22 PM
dynamic ranges to calculate average	teatree	Excel	1	11-11-2016 10:11 AM
Calculate average age	FTL	Excel	1	08-09-2016 06:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:01 PM.