space left for future entry = #DIV/0!

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?
 
C

CLR

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
 
C

clooney

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.
[email protected]
 
Top