Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Copying a formula and changing ONE value... | Excel Worksheet Functions | |||
Changing the Color of a Word in Formula | Excel Worksheet Functions | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
countif array formula | Excel Worksheet Functions |