Thread
:
Exclude zeros from pivot table averages
View Single Post
#
1
Posted to microsoft.public.excel.misc
Matthew
external usenet poster
Posts: 47
Exclude zeros from pivot table averages
Would like to understand how to exclude zeros from pivot table averages;
a - 100
a - 100
a - 0
above should result in an avg of 100, not 66.7.
Reply With Quote
Matthew
View Public Profile
Find all posts by Matthew
Exclude zeros from pivot table averages