B
Barb Reinhardt
How do I use COUNTIF if I want the criteria to be greater than the value in
cell B1?
Thanks in advance.
Barb Reinhardt
cell B1?
Thanks in advance.
Barb Reinhardt
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
=COUNTIF(rng, ">B1")
=COUNTIF(rng, ">B1")
B
Bob Phillips
JE means
=COUNTIF(rng,">"&B1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
=COUNTIF(rng,">"&B1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
J
JE McGimpsey
You are so right. Once again I shouldn't be posting when distracted...
Thanks for the correction.
Thanks for the correction.
R
Ragdyer
Was the distraction pretty?<g>
J
JE McGimpsey
Ragdyer said:Was the distraction pretty?<g>
There's only one right answer to that...