Problems UsiIng COUNTIF Function

[jmitchj]

I am trying to use the COUNTIF function, however the result of the Function is not being returned in the cell...The Formula remains in the cell...Can someone tell me how I get the result to return in the cell?

 

[barbola]

type = in front of the formula.
=countif(....

 

[jmitchj]

I have got the = sign in front, but it still doesn't work

 

[Joe Was]

=Countif(A1:A25,">0")

The syntax is (the range to count, "the test")

You can make the test most conditions.
"=x" will count all the cells in your range that contain "x" and x can be any text or value.

If this does not help, tell us what you have for data and what you want to count! JSW

 

[Mark W.]

Your cell is formatted as Text. Change its format to General or some other appropriate number format, and re-edit the cell.
This message was edited by Mark W. on 2002-06-14 12:10

 

[jmitchj]

This is the Function that I am using:
=COUNTIF(d4:d6,1)
Where I want to count the number of occurences of the Number 1 in a range of cells.
The formula remains in the cell after being typed in although the result of the formula in the Pop up box returns the correct result.

 

[jmitchj]

Thank You!!...My cell was formatted as Text..I appreciate the help

 

[Joe Was]

Change your formula to this style!

=COUNTIF(A1:A13,"=1")

Change your range, but use "=1" as your test, keep the quotes and equal sign in your test!

 

[arunabha67509]

Respected Expert(s), The following formula is not working for me where I want to figure out the count of "F" participants in a set of data over the age of 18 =COUNTIFS($L$7:$L$40,"F",$D$7:$D$40,">18")

<tbody>
</tbody>