Since you *still* haven't posted an actual formula that you're using, I'll
make a guess that:
Column A = subject
Column B to E = grades
Column F = date
Column G = AVG.

With data in A2 to F10.

I'll assume your problem is not this simple, but just to start somewhere,
try this in G2 and copy down:

=(F20)*(SUM(B2:E2)/4)

NOW ... post back with your comments !
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ArthurN" wrote in message
...
Hi,
I'm sorry for the ambiguity. What I want is this- I use Pocket Excel to
keep
my students' grades. And the table looks this way:
--------------------------
assign !Ann!Kate!date
--------------------------
reading! 93 ! !03/12
writing ! 90 ! 63 !03/13
-------------------------
I'm using different functions to count the average, etc.
The blank cell in the first line is an academic debt, which, until
changed,
is counted as "0". When counting the average, I count the number of blank
cells in the rows that have date cell not empty as "0". And I don't know
how
to do that.

Thanks,
ArthurN