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 |
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 |
: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 |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com