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