Hello,
I've attached an image below but I'm not sure you can see it. Jan - Dec and YTD average are in cells I5 to I17 and their corresponding values are in cells J5 to J17.
I need to average the column of twelve monthly percentage scores. The problem I'm having is that the cells all pull their own values from other cells on the same sheet. The values are averages of each month, Jan, Feb, etc. Those other cells are currently blank. For example, lets say this is March 2015. I have scores for January, February, and March but April to December are all empty so the values in those cells are all #div/0. How do I calculate a year to date average for the year while ignoring the cells with #div/0?
Thanks for your help
Bookmarks