Cell Reference

[Felix]

I need a formula on one worksheet (such as =$A$22+50) whereas the 22 comes
from an entry in a cell.

I tried with “INDIRECTâ€, but did not succeed... Any other ideas?

 

[Mike H]

try this

=INDIRECT("A"&A1)+50

so if you now enter 22 in a1 you will get the sume if A22 + 50

Mike

 

[Felix]

That one worked fine!

But here is another problem with the same background:

Wit the formula

=COUNT.IF($B$5:$B$44;"*("&$AN5&")*")

I want to check a range in col. B. Start is always $B$5 but the end (line
44) can change. I would like to enter the line number in a cell and have the
formula use this (line)-number.

The formulae themselves are in the range AO5:AO33, the (line)number to be
used in the formula should go to AO37

Is this also possible?