Referencing a cell with Countif
 

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.

Referencing a cell with Countif
 

I guess your criteria is supposed to mean less than O7?

Try it like this:

=COUNTIF(O8:O50000,"<"&O7)


--
Biff
Microsoft Excel MVP


"rhhince" wrote in message
...
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.

Referencing a cell with Countif
 

=COUNTIF(O8:O50000,"<" & O7)

--
Gary''s Student - gsnu2007k


"rhhince" wrote:

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.

Referencing a cell with Countif
 

Hi,

I'm not sure what the minus sign was for, try this

=COUNTIF(O8:O50000,"<"&O7)

Mike

"rhhince" wrote:

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.

Referencing a cell with Countif
 

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.

--
Rick (MVP - Excel)


"rhhince" wrote in message
...
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.

Referencing a cell with Countif
 

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

Thanx for the help.



On Jan 14, 2:17*pm, "T. Valko" wrote:
I guess your criteria is supposed to mean less than O7?

Try it like this:

=COUNTIF(O8:O50000,"<"&O7)

--
Biff
Microsoft Excel MVP

"rhhince" wrote in message

...

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.

Referencing a cell with Countif
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"rhhince" wrote in message
...
What worked was this:
=COUNTIF(O8:O50000,""&O7) and for counting negative numbers
=COUNTIF(O8:O50000,"<"&-O7)

Thanx for the help.



On Jan 14, 2:17 pm, "T. Valko" wrote:
I guess your criteria is supposed to mean less than O7?

Try it like this:

=COUNTIF(O8:O50000,"<"&O7)

--
Biff
Microsoft Excel MVP

"rhhince" wrote in message

...

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.