software

I am trying to put in a cell reference into a a countif formula. As
referenced below, I would like to insert the formula from D37 into the
formula in E37. As the formula in D37 equals 37, I am trying to paste this
formula over the number quot;37quot; in cell E37. However, this isn't working. Any
help would be appreciated.

E37: =ROUND(1/COUNTIF($C$37:$C$58,C37),2) equals 0.5
D37: =MATCH(B37,$B$1:$B$2259,0) = 37

Try this:

=ROUND(1/COUNTIF($C$37:$C$58,INDIRECT(quot;Cquot;amp;D37)),2)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;briankquot; gt; wrote in message
...
gt; I am trying to put in a cell reference into a a countif formula. As
gt; referenced below, I would like to insert the formula from D37 into the
gt; formula in E37. As the formula in D37 equals 37, I am trying to paste
this
gt; formula over the number quot;37quot; in cell E37. However, this isn't working.
Any
gt; help would be appreciated.
gt;
gt; E37: =ROUND(1/COUNTIF($C$37:$C$58,C37),2) equals 0.5
gt; D37: =MATCH(B37,$B$1:$B$2259,0) = 37