View Single Post
  #3   Report Post  
Bernard Liengme
 
Posts: n/a
Default Using Excel as a Gradebook:Calculating sum excluding blanks and ze

But if my 'total' you mean count then use =COUNTIF(A1:A47,"0")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"morgan.lintz" wrote in message
...
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?