Hi!

Hope I am clear enough

Well, not really!

What do you mean by: Lets say I am in position F1

Is that the end of your data range? Is that the cell you have selected?

Biff

"Yossi" wrote in message
...
Hi,
Is it possible to use ADDRESS comman result as a reference somehow?
More specifically - I am trying to count values from a certain offset to
my
current position to my position.
For example:
A1 B1 C1 D1 E1 F1 ... AA1
1 1 1 3

Lets say I am in position F1 and I want to count the values from B1 to D1,
where B1 is determined by the value in AA1 (AA1 tells me how far backward
I
should check).
If the value in AA1 was 4 I would check from A1 to D1.
Hope I am clear enough
thanks