GradeBook

  • Thread starter Thread starter WannaKooky
  • Start date Start date
W

WannaKooky

Spanks. That worked for the numbers.

Now my problem is the Final Grade Average. It's counting the empt
cells as 0 and putting it into the average.

Here is my formula for that:

=AVERAGE(C5+D5+H5,K5+L5+P5,S5+T5+X5,AA5+AB5+AF5,AI5+AJ5+AN5,AQ5+AR5+AV5,AY5+AZ5+BD5,BG5+BH5+BL5,BO5+BP5+BT5)

So say I only have data inputted for C5, D5, and H5, but the rest ar
blank, then the above formula computes the empty cells as zero.

Do I try that ISNUMBER there somehow or is there another way
 
WannaKooky said:
Spanks. That worked for the numbers.

Now my problem is the Final Grade Average. It's counting the empty
cells as 0 and putting it into the average.

Here is my formula for that:

=AVERAGE(C5+D5+H5,K5+L5+P5,S5+T5+X5,AA5+AB5+AF5,AI5+AJ5+AN5,AQ5+AR5+AV5,AY5+AZ5+BD5,BG5+BH5+BL5,BO5+BP5+BT5)

So say I only have data inputted for C5, D5, and H5, but the rest are
blank, then the above formula computes the empty cells as zero.

Do I try that ISNUMBER there somehow or is there another way?
Click to expand...

Maybe you can try this:

=sum(your range)/countif(your range,">0")
 
Back
Top