Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |