I need a formula on sheet 8 that will show the average of the percents shown on the other sheets in cell C6. Note that one of the C6 cells has been lift blank and I do not want it to be averaged into the total. Only if the percent is above 0.
thanks in advance.
Bookmarks