Hi Guys,
I'm having a problem, maybe silly but is making me mad, I'm trying to get an average result from a column in a Pivot table, but if I have zeros the result come back incorrect.
I've attached a file to show what I'm looking for, the result in dark yellow is what I want.
As always thanks in advance
Dip
--------------------------------------------------------------------------------------------------------------------------------
Faith is a Oasis in the desert that can never be reached by the caravan of thinking.
Bookmarks