View Single Post
  #1   Report Post  
morgan.lintz
 
Posts: n/a
Default Using Excel as a Gradebook:Calculating sum excluding blanks and ze

I am attempting to use Excel as a gradebook and I would like to total the
values of a series of columns where the values are not blank and are greater
than 0.
Should I test each value in a range for blank or 0?
If so, how would I go about doing that?
I have basic programming skills based out of Java (very elementary), and
would like to understand what I am doing. So if you reply, could you please
explain?