Try this paste this into cell B1 then fill in cells A1 thru A10
=IF(ISERROR(SUM(A1:A10)/COUNTIF(A1:A10,"0")),0,SUM(A1:A10)/COUNTIF(A1:A10,"0"))
"Carissa" wrote:

Hello,

I am creating a spreadsheet using percentages and getting their averages.
Right now, I am using the regulare AVERAGE function, however, if cells are
blank I get #DIV/0!. I understand it's because I have no values, however I
will soon and I need something more presentable than that error.

For instance, I have 2 rows with 6 colums, 7 including the average at the
end. I need the total of the 2 rows average and I only have data in the first
2 colums on the first row.

Any ways, my question is there a way I can omit the blank cells or skip over
them until there is data placed inside? Or a way to get around it? Any help
would be much appreciated. Thank you in advance.