I have set up a volleyball spreadsheet. Play is best of 5 matches. I have set up hitting statistics, so I will have 3 columns of numbers and a fourth with hitting percentage for each potential set. if the match only goes three games I am getting an error on my four and fifth set. I have used =AVERAGE(E5,I5,M5,Q5,U5), I know I will always have 3 columns filled but not 5. I am getting the #### in the total field when I try to get an average. any help would be greatly appreciated.
Gary
Gary