| 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 | |||
Hybrid Mode
