| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
countif, dinamic criteria
Hi All!
(thanks in advance for your help, this is a great resource) I need to count the number of values in a matrix B2: S19 higher than the value in cell H23 it is not a static value, I want to be able to change it and have the numbers adjusted on the fly. Thanks! Stan |
|
#2
|
|||
|
|||
|
Hi
=COUNTIF(B2:S19,""&H23) -- Regards Frank Kabel Frankfurt, Germany "Stan Altshuller" schrieb im Newsbeitrag ... Hi All! (thanks in advance for your help, this is a great resource) I need to count the number of values in a matrix B2: S19 higher than the value in cell H23 it is not a static value, I want to be able to change it and have the numbers adjusted on the fly. Thanks! Stan |
|
#3
|
|||
|
|||
|
:O) Why didnt I think of that?
THANKS!!! Stan "Frank Kabel" wrote in message ... Hi =COUNTIF(B2:S19,""&H23) -- Regards Frank Kabel Frankfurt, Germany "Stan Altshuller" schrieb im Newsbeitrag ... Hi All! (thanks in advance for your help, this is a great resource) I need to count the number of values in a matrix B2: S19 higher than the value in cell H23 it is not a static value, I want to be able to change it and have the numbers adjusted on the fly. Thanks! Stan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel error using Dinamic Table | Excel Worksheet Functions | |||
| Countif - Countif | Excel Worksheet Functions | |||
| How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
| countif, again | Excel Worksheet Functions | |||
Linear Mode
