ExcelBanter - Exclude zero values using average function in a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Exclude zero values using average function in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/97762-exclude-zero-values-using-average-function-pivot-table.html)

abs

Exclude zero values using average function in a pivot table

I am trying to sum up the average value in a pivot table, but the result are
including the blank cells give me an incorrect average value

scubadiver

Exclude zero values using average function in a pivot table

=sum(XX:XX)/countif(XX:XX, "0")

All times are GMT +1. The time now is 03:20 PM.