Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude zero values using average function in a pivot table
=sum(XX:XX)/countif(XX:XX, "0") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Pivot table-How to exclude zero values from it. | Excel Worksheet Functions | |||
Grand Average in Pivot Table? | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel |