space left for future entry = #DIV/0!

  • Thread starter Thread starter clooney
  • Start date Start date
C

clooney

I'm making a sheet to calculate my grades, but since its the beginning
of the semmester, the spaces aren't filled in yet. How do i ignore a
cells until they have a value?
 
Specifically, it depends on the formula......
instead of
=AVERAGE(A1:A10)
you could use
=SUM(A1:A10)/COUNT(A1:A10)

Vaya con Dios,
Chuck, CABGx3
 
I tried the count function, but doesnt that just count the number of
cells that have entries rather than an actual sum..?

email me if you want and Ill send you the file so you can take a look
yourself.

thanks.
(e-mail address removed)
 
Back
Top