=COUNTIF(A5:A64,"<"&a66)



OrlandoFreeman wrote:

I want to COUNTIF A5:A64... I have an AVERAGE formula in A66, and its result
(e.g. 485.6) will frequently change as new rows and data are added. You can
countif fine if you enter for example COUNTIF(A5:A64, "<485.6"). But, I would
like to enter the cell (e.g. "<A66") not the result of my average formula
every time that that result changes.

Thank you for your help.

--

Dave Peterson