Hi all,

I'm creating a spreadsheet for work and it will basically consist of a list of percentages followed by an average.

I tried using the =AVERAGE function BUT it returned DIV/0! errors. To combat that I used the formula +IF((COUNT(B6:B13)>0),AVERAGE(B6:B13),"") so that the average is blank if the cells are empty.

Only problem with that is that the COUNT function is returning a "Refers to empty cells error" on every formula cell. I could just turn off the error checking but because this is used on loads of computers and potentially ones that I don't have access to I can't do that for all of them.

Anyone got any other suggestions?

Thanks,

Kevin