Contents of Cells into Formulas

  • Thread starter Thread starter Raymond Wood
  • Start date Start date
R

Raymond Wood

How do I input the contents of a cell into another formula?

I.e. in cell A1 there is a formula which gives me
different ranges:

=IF(E4=30,"$AK$8:$AK$471","$AL$8:$AL$471")

I now want to put another formula in cell A2 that will
read:

=COUNTIF("Value of cell A1",">=5");

where "Value of cell A1" will be the result of the formula
in cell A1.

i.e. if the formula in cell A1 returned $AK$8:$AK$471,
then the countif formula would read

=COUNTIF($AK$8:$AK$471,">=5");

whereas if the formula in cell A1 returned $AL$8:$AL$471,
then the countif formula would read

=COUNTIF($AL$8:$AL$471,">=5)???
 
Raymond,

Use the INDIRECT function. For example

=COUNTIF(INDIRECT(A1),">=5");


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top