Thanks, you are a mindpace maker.
I will be able to sleep tonight.

You are really a kind person.

I owe you one

"Toppers" wrote:

=INDIRECT("$A"& AN22)

will refer to $A15 i.e. the value in $A15

Is this what you require?

"Victor" wrote:

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Good night from the UK! And thanks for the feedback.

"Victor" wrote:

Thanks, you are a mindpace maker.
I will be able to sleep tonight.

You are really a kind person.

I owe you one

"Toppers" wrote:

=INDIRECT("$A"& AN22)

will refer to $A15 i.e. the value in $A15

Is this what you require?

"Victor" wrote:

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Good night from spain, and, hey it's been my pleasure

"Toppers" wrote:

Good night from the UK! And thanks for the feedback.

"Victor" wrote:

Thanks, you are a mindpace maker.
I will be able to sleep tonight.

You are really a kind person.

I owe you one

"Toppers" wrote:

=INDIRECT("$A"& AN22)

will refer to $A15 i.e. the value in $A15

Is this what you require?

"Victor" wrote:

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all