ExcelBanter - RE COUNTIF: use

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - RE COUNTIF: use < before a cell (https://www.excelbanter.com/excel-discussion-misc-queries/97129-re-countif-use-before-cell.html)

OrlandoFreeman

RE COUNTIF: use < before a cell

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

RE COUNTIF: use < before a cell

=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

All times are GMT +1. The time now is 12:18 AM.