Averaging a column with blank cells

**dmackco** · 08-28-2012, 05:14 PM

I am using Word 2007 and have created a table with values that I want to average. There are blank cells in the column that I can't delete and entering a zero changes the average value returned.

**oeldere** · 08-28-2012, 05:15 PM

with an pivot table of with sumproduct.

You get better help if you post an Excel-example of your workbook, without confidential information.

**tom1977** · 08-28-2012, 05:17 PM

try this

Formula:

Please Login or Register  to view this content.

**macropod** · 08-28-2012, 10:04 PM

Hi dmacko,

You will need to use an explicit range reference (eg a formula field coded as {=AVERAGE(C1:C8)}, where the field braces (ie '{}') are created via Ctrl-F9). With such an approach, blank cells will be ignored.

oeldere and tom1977: Those approaches might work for Excel, but the OP has a Word table. Word is not Excel and does not support pivot tables or AVERAGEIF.