Link to home
Create AccountLog in
Avatar of recycleaus
recycleausFlag for Australia

asked on

Pivot table - average if not zero

Attached is a spreadsheet which contains 2 columns I am trying to average out, grouped by month, using a pivot table. Some of the cells contain no value.

How can I make the pivot table exclude the zero values when calculating the averages?

Thanks
Troy
Mn.Zn-Pricing.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of recycleaus

ASKER

Worked a charm - very clever solution!