Thread
:
Exclude zero values using average function in a pivot table
View Single Post
#
2
Posted to microsoft.public.excel.misc
scubadiver
external usenet poster
Posts: 55
Exclude zero values using average function in a pivot table
=sum(XX:XX)/countif(XX:XX, "0")
Reply With Quote
scubadiver
View Public Profile
Find all posts by scubadiver