Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
COUNTIF across multiple sheets | Excel Worksheet Functions | |||
click & drag not working | Excel Discussion (Misc queries) | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) |