ExcelBanter - Countif Formula with changing criteria

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

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

- - Countif Formula with changing criteria (https://www.excelbanter.com/excel-discussion-misc-queries/23174-countif-formula-changing-criteria.html)

Stephen

Countif Formula with changing criteria

Hi. I'm trying to create a formula that will count how many numbers in a list
of ten that are greater than a changing number in a cell. The cell changes as
it has a formula attached to it. I used as the criteria b1, but for some
reason this doesn't work. As this number changes it has to be greater than
whatever the cell value is at that time.
--
Thanks!

Stephen

try
=sumproduct(--(rangeB1),1)

"Stephen" wrote:

Hi. I'm trying to create a formula that will count how many numbers in a list
of ten that are greater than a changing number in a cell. The cell changes as
it has a formula attached to it. I used as the criteria b1, but for some
reason this doesn't work. As this number changes it has to be greater than
whatever the cell value is at that time.
--
Thanks!

Stephen

Aladin Akyurek

=COUNTIF(Range,""&B1)

Stephen wrote:
Hi. I'm trying to create a formula that will count how many numbers in a list
of ten that are greater than a changing number in a cell. The cell changes as
it has a formula attached to it. I used as the criteria b1, but for some
reason this doesn't work. As this number changes it has to be greater than
whatever the cell value is at that time.

All times are GMT +1. The time now is 11:29 PM.