Howdy, first post here.

I'm using Pivot Table to summarize numeric results, formatted as numbers, to show average, count and standard deviation. These are arranged in columns by a sample size.

I'm getting normal results for average in the sample size columns and #DIV/0! in the Total column, even though the count and standard deviation show the correct values in both columns. When I use Excel's average function in the toolbar at the bottom there is no error. The number of numbers averaged is several dozen. There are no blanks in the data.

If I change the table option for showing errors to ??, it shows ??, so the table thinks it is finding an error.

Any ideas why the table is finding an error?