Average Without Blanks & Dynamic Range

[EXCELlent Emily]

I have a spreadsheet that I am needing help with. I have inserted a formula to automatically populate a scoring system number based on what column the data is put in (Below/Meets/Exceeds). For example, D8 reads =IF(C8<>"","3","")... I am needing to calculate the Average of these Auto populated numbers (Column D,F,E) but keep running into #DIV/0 errors. I am assuming bc the cells are not actually blank. Any suggestions on how to make this work?

 

[MrTomasz]

did you try averageif function?

=AVERAGEIF(YourRange; "<>0")

 

[EXCELlent Emily]

did you try averageif function?

=AVERAGEIF(YourRange; "<>0")

Yes. I keep getting the same error. #DIV/0!

 

[MrTomasz]

I can see green triangles in some cells. What they say? Probably that you store number as text.

Try to convert to number.

 

[EXCELlent Emily]

I can see green triangles in some cells. What they say? Probably that you store number as text.

Try to convert to number.

I noticed that as well as soon as I posted thread... I have converted and still getting #DIV/0! error.