Help With Gradebook and #DIV/0 error

**adunning** · 02-01-2013, 04:56 PM

I am setting up gradebooks for a pilot for my department in my school and I need to find a way to use my gradebook without having #DIV/0 errors all over it. They go away when enough data is present but students want to know their grades the whole time. In every category that I have an average or a mode for they show up. I really need a way to fix this. I included a googledoc version to get help if possible. I would really appreciate any help I can get. Everything would work perfect if I could fix that. If you can either post something here that a relative novice could interpret or edit the googledoc so I can use those changes I would REALLY appreciate it.

https://docs.google.com/spreadsheet/...1E&usp=sharing

**Moo the Dog** · 02-01-2013, 05:35 PM

With Excel 2010 you can hide errors using the IFERROR function like so:

To display a blank cell:
=IFERROR(SUM(B5:B35)/COUNTIF(B5:B35,">0"),"")

To display a 0:
=IFERROR(SUM(B5:B35)/COUNTIF(B5:B35,">0"),0)

You can also use AVERAGEIF, instead of SUM/COUNTIF:
=IFERROR(AVERAGEIF(B5:B35,">0"),"")
=IFERROR(AVERAGEIF(B5:B35,">0"),0)

- Moo

**adunning** · 02-02-2013, 12:47 AM

Thank you SO much. That helped more than you know. I don't suppose you know how to fix my last problem so that I don't have to make a seperate thread for this. I have a wieghted average from a chart on another sheet. How could I make the following function on that only counts if the cells aren't blank? I am assuming it would be a sumif or countif but I am not sure how to do it.

=IFERROR(SUM(K6)*Settings!$G$5+SUM(P6)*Settings!$G$6+SUM(X6)*Settings!$G$7,"")

Again, thanks a lot