#1
|
|||
|
|||
Calculate average in a column, but ignore empty cells?
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:
92 92 92 130 134 104 83 113 96 74 122 If I enter zeroes in all the empty cells, the =AVG(BELOW) function returns an average of 61: 61 61 61 0 130 134 104 0 0 83 0 0 0 113 96 74 122 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. 107 107 130 134 104 83 113 96 74 122 |
#2
|
||||
|
||||
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 |
average, null |
|
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 |