Why can't COUNTIF condition reference a cell?

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
M

ModelerGirl

I'd like to count the number of cells in a column which contain value
less than c3. I tried the following formula:

COUNTIF(A1:A20,"<c3")

and it gives me 0, which is not accurate.

What am I doing wrong?

Thanks,

Kat
 
Try:

=COUNTIF(A1:A20,"<"&C3)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I'd like to count the number of cells in a column which contain values
less than c3. I tried the following formula:

COUNTIF(A1:A20,"<c3")

and it gives me 0, which is not accurate.

What am I doing wrong?

Thanks,

Kate
 
What is c3? It's like saying count values less than "Apeman"
If all values have letter c and a number(s) you can use

=SUMPRODUCT(--(--SUBSTITUTE(A1:A20,"c","")<3))
 
Hi ModelerGirl!

Use:

=COUNTIF(A1:A20,"<"&C3)

Your formula:
=COUNTIF(A1:A20,"<C3")
Counts entries of the text <C3 in A1:A20

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Yikes! Somehow I thought c3 was not a cell ref since A1:A20 are in caps..

--

Regards,

Peo Sjoblom

Peo Sjoblom said:
What is c3? It's like saying count values less than "Apeman"
If all values have letter c and a number(s) you can use

=SUMPRODUCT(--(--SUBSTITUTE(A1:A20,"c","")<3))
Click to expand...
 
Back
Top