I am tracking production for our physicians on monthly basis. I also want to be able to have a rolling average of the production for the year. My only challenge is that the range i am selecting has 0 values (for the months that didn't happen yet). Those 0 values are there because the column has values derived via a SUM formula.
Is there any way to average the whole year but exclude the 0 values? And when those 0 values turn into a different value, the average will pick them up?
Thanks.
kate
Bookmarks