in Excel the COUNTIF function doen't seem to work if the criteria is linked to a cell ex ">A1"
What's the way round it? Thx
Quick silly question
-
Dizzy
- Posts: 0
- Joined: Thu Jan 01, 2004 12:00 am
Quick silly question
I would probably use somthing like ">"&A1 to dynamically construct a string using the cell A1.
"Although the code snippet makes taking over the earth look fairly easy, you don't see all the hard work going on behind the scenes." - Programming F#, Chris Smith
-
nodoodahs
- Posts: 0
- Joined: Thu Jan 01, 2004 12:00 am
Quick silly question
Another way: array function.
=count(if(arraytobeanalyzed>cell1,arraytobecounted)) and then shift+control+enter to make it an array, it'll show with {} around the formula in your toolbar. Counted and analyzed ranges are usually the same.
Array works well in combinations, =count(if(thisrangethis other, countingrange))) ...
=count(if(arraytobeanalyzed>cell1,arraytobecounted)) and then shift+control+enter to make it an array, it'll show with {} around the formula in your toolbar. Counted and analyzed ranges are usually the same.
Array works well in combinations, =count(if(thisrangethis other, countingrange))) ...
I haven’t seen a beatin’ like that since somebody stuck a banana in my pants and turned a monkey loose.
-
RFMontraz
- Posts: 0
- Joined: Thu Jan 01, 2004 12:00 am