Countif, not working.
 

Can someone please help.

I am asking a cell to do below,

=COUNTIF(W3:W26,"Initial Caseload")

But it is not counting all "Initial caseload", but only the first two
in the column. I have tried formatting the column, but nothing.

Many thanks.


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=563178

Countif, not working.
 

Hi
use this way:
=COUNTIF(W3:W26,"Initial Caseload*")


"Clash" wrote:


Can someone please help.

I am asking a cell to do below,

=COUNTIF(W3:W26,"Initial Caseload")

But it is not counting all "Initial caseload", but only the first two
in the column. I have tried formatting the column, but nothing.

Many thanks.


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=563178

Countif, not working.
 

Thanks very much.


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=563178