Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to write a count-if-not function?
I am trying to write a function that counts the the cells within a range that
do not include a certain phrase. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to write a count-if-not function?
Jsatter, Take a look at the IS Functions in Excel, I am sure there is something here that will help Cheers Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=562103 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to write a count-if-not function?
the quickest way to achieve what you're after is to use the FIND
function to search the text, which will return an error if it can't find the relevant text. You can then use the ISERROR function with a '--' infront to return ones and zeros which you can simply add up. You will need to enter this as an array formula (hold ctrl+shift whilst pressing enter). So an example might be: =SUM(--ISERROR(FIND("foobar",A1:A5))) Rob Jon Quixley wrote: Jsatter, Take a look at the IS Functions in Excel, I am sure there is something here that will help Cheers Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=562103 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to write a count-if-not function?
Try:
=COUNTIF(A1:A5,"<*my phrase*") HTH "Jsatter" wrote: I am trying to write a function that counts the the cells within a range that do not include a certain phrase. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
Count function | Excel Worksheet Functions | |||
... Count Function ... with any character ... | Excel Discussion (Misc queries) | |||
Count Function Help | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |