embed cell reference in formula

[koamapping]

Hello,

Please send advice regarding utilizing a cell address in a function

Currently have cell reference "$E$8" stored as a formula in cell E372 and want to use $E$8 to describe range in COUNTIF function

Failed method
=COUNTIF((INDIRECT(ADDRESS(E,372))):E371,">122")

Desired affect
=COUNTIF($E$8:E371,">122")


INDIRECT does not seem to work because even though the referenced cell displays a value of $E$8 the formula is =TEXT('Lompoc Table'!E373,"") and the formula in 'Lompoc Table'!E373 is =ADDRESS(E371,E372) and E371 is =MATCH(TRUE,INDEX(E3:E368>=800,0),0)


Do you happen to know if there is a function to convert formulas to values?

Any ideas of a solution would be much appreciated

 

[pgc01]

Hi

Try:

=COUNTIF(INDIRECT(E372):E371,">122")

 

[koamapping]

It seems to be working.
Thank you very much.

 

[pgc01]

You're welcome. Thanks for the feedback.