RE COUNTIF: use < before a cell

From: OrlandoFreeman <OrlandoFreeman_at_discussions.microsoft.com>
Date: Fri, 30 Jun 2006 19:45:01 -0700

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. Received on Fri Jun 30 2006 - 19:45:01 PDT