Referencing a cell with Countif

  • Thread starter Thread starter rhhince
  • Start date Start date
R

rhhince

Hi. I am trying to reference cell O7 in this countif function.

=COUNTIF(O8:O50000,-"<&O&7")

Can anyone help me with this one? Thanks.
 
I guess your criteria is supposed to mean less than O7?

Try it like this:

=COUNTIF(O8:O50000,"<"&O7)
 
And if the minus sign was a typo, then perhaps this is what you want...

=COUNTIF(O8:O50000,O7)

Note: It is always useful to include descriptive text as to what you are
trying to do rather than let a non-working formula try to convey it.
 
What worked was this:
=COUNTIF(O8:O50000,">"&O7) and for counting negative numbers
=COUNTIF(O8:O50000,"<"&-O7)

Thanx for the help.
 
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


What worked was this:
=COUNTIF(O8:O50000,">"&O7) and for counting negative numbers
=COUNTIF(O8:O50000,"<"&-O7)

Thanx for the help.
 
Back
Top