COUNTIF

  • Thread starter Thread starter swarfmaker
  • Start date Start date
S

swarfmaker

I am trying to use countif to count the number of times the value of cell I2
occurs in column D but the following does not work.
=COUNTIF(D6:D36,I2)
This returns zero but I know that there are 2 occurances of the number in I2

Any help appreciated.

Iain
 
I am trying to use countif to count the number of times the value of cell I2
occurs in column D but the following does not work.
=COUNTIF(D6:D36,I2)
This returns zero but I know that there are 2 occurances of the number in I2

Any help appreciated.

Iain
Click to expand...

You do not post examples of exactly what is in I2 and what is in column D.

However, if the values appear identical, then most likely one is text and the
other numeric. The "fix" would depend on which is which and how the values are
generated.

If you are looking for a value in I2 that may be a part of the value in column
D, then your syntax is incorrect.


--ron
 
Ron Rosenfeld said:
You do not post examples of exactly what is in I2 and what is in column D.

However, if the values appear identical, then most likely one is text and
the
other numeric. The "fix" would depend on which is which and how the
values are
generated.

If you are looking for a value in I2 that may be a part of the value in
column
D, then your syntax is incorrect.


--ron
Click to expand...

The values in column 2 are numeric (Blood Glucose values) in the range 2.5
to 28
The value in I2 is numeric, in this case 4 but can be changed by the user.
I need to count all values in column D that are less than the value in I2.

Iain
 
The values in column 2 are numeric (Blood Glucose values) in the range 2.5
to 28
The value in I2 is numeric, in this case 4 but can be changed by the user.
I need to count all values in column D that are less than the value in I2.

Iain
Click to expand...

Well, that's different than what you first posted.

To count all the values in column D that are *LESS THAN* the value in I2, use:

=COUNTIF(D:D,"<"&I2)

or, if it is just part of Column D that you are counting:

=COUNTIF(D6:D32,"<="&I2)


--ron
 
Back
Top