Pivot table - how to exclude missing data from an average

[Thomas36]

Hi,
I have numerical data, for some participants the data is unavailable so appears as N/A.
If i create a pivot table, i do not want to replace the NA with 0 as my average will be incorrect. I only want to have an average of those cells that have data in them.
Is there a way if doing this without replacing empty cells with 0?
Thank You

 

[jasonb75]

Try replacing the N/A's with null strings, for example =IFERROR(existing formula,"") The pivot average will ignore them. If you don't want the cells to appear empty then you could use something like "No Data" instead of "".