Once I posted a question if I could reference the cell dynamically when the
reference equals some other cell value, for example, and some nice people
here advised me to use the "indirect" function, which worked perfectly for me
and made me happy until I discovered this function missing on my PDA running
Windows 2003 SE. Is there some workaround? I'm getting so desperate...

You could have posted an example of the formula in question.

However, as an example:

=SUM(A1:A10)

Cell references for start and end of Sum() range are in B1 and C1.

=SUM(INDIRECT("A"&B1&":A"&C1))

Alternate formula:

=SUM(INDEX(A:A,B1):INDEX(A:A,C1))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"ArthurN" wrote in message
...
Once I posted a question if I could reference the cell dynamically when the
reference equals some other cell value, for example, and some nice people
here advised me to use the "indirect" function, which worked perfectly for
me
and made me happy until I discovered this function missing on my PDA running
Windows 2003 SE. Is there some workaround? I'm getting so desperate...

What I meant is:
=Average(A1:_this cell equals the value of another cell, which in it's turn
might be a function like =Address(R1C4)) In this case, the Indirect function
would capture the result of the Address function and the Average function
will work as expected. But, as I told, the indirect function is missing on
PPC.
It has the Index function, though, but I don't know how to use is it in this
case.
Regards,
ArthurN

Is there a reason why you can't post an exact formula that you're looking
for help to revise?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"ArthurN" wrote in message
...
What I meant is:
=Average(A1:_this cell equals the value of another cell, which in it's turn
might be a function like =Address(R1C4)) In this case, the Indirect function
would capture the result of the Address function and the Average function
will work as expected. But, as I told, the indirect function is missing on
PPC.
It has the Index function, though, but I don't know how to use is it in this
case.
Regards,
ArthurN

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

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