Exclude zero values using average function in a pivot table

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of % in pivot table 1
Pivot Table Average Problem 2
Pivot table Average with [h]:mm format 5
pivot table defaults 2
Pivot Table: Summing Average Values 4
pivot table, Average formula 3
Average Formula Help 2
Average of Subtotals in Pivot Table 0

Top