COUNTIF Criteria
Posted by Paul Snyder on February 23, 2001 8:22 AM
I want to substitute a cell for the criteria element in a COUNTIF function i.e. =COUNTIF(a5:a456, >d12). However, I cannot find the proper grammer for the expression. This does not work =COUNTIF (a5:a456, ">d12"). Neither does any variation I have tried.
Help please. Thanks.
Paul Snyder
Posted by Aladin Akyurek on February 23, 2001 8:43 AM
Assume you have some value in d2.
=COUNTIF(a5:a456, ">"&d12)
will work.
Aladin
Posted by Dave Hawley on February 23, 2001 8:44 AM
I want to substitute a cell for the criteria element in a COUNTIF function i.e. =COUNTIF(a5:a456, >d12). However, I cannot find the proper grammer for the expression. This does not work =COUNTIF (a5:a456, ">d12"). Neither does any variation I have tried.
Hi Paul
Try this
=COUNTIF(A5:A456, ">" & D12)
Dave
OzGrid Business Applications
Posted by Dave Hawley on February 23, 2001 9:19 AM
Echo.......
That's what I said :O) Aladin
OzGrid Business Applications
