|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 11th, 2010, 10:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count all text values except a certain one
if i have the word 'ditto' scattered among a bunch of names (text), how do i
count every value that's not 'ditto' ? am i trying to combine "COUNTIF" value with "NOT" criterion...? 
|
|
#2
February 11th, 2010, 11:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count all text values except a certain one
One thought ..
Assuming your source data running down in col A you could use this in say, B1: =COUNTA(A:A)-COUNTIF(A:A,"*"&"ditto"&"*") voila? zonk YES below -- Max Singapore --- "justjill111" wrote: if i have the word 'ditto' scattered among a bunch of names (text), how do i count every value that's not 'ditto' ? am i trying to combine "COUNTIF" value with "NOT" criterion...?
|
|
#3
February 11th, 2010, 11:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count all text values except a certain one
Try this...
=COUNTIF(A1:A10,"ditto") The operator means "not equal to". I find it easier to think of it as meaning "is not". Note that will count empty cells. -- Biff Microsoft Excel MVP "justjill111" wrote in message ... if i have the word 'ditto' scattered among a bunch of names (text), how do i count every value that's not 'ditto' ? am i trying to combine "COUNTIF" value with "NOT" criterion...?
|
|
#4
February 11th, 2010, 11:27 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count all text values except a certain one
sorry but it returned the entire count. let me be more specific.
the names are contained E7:E98 the column looks something like this: jane max ditto ditto ditto laurie kelly dittto does this help? "Max" wrote: One thought .. Assuming your source data running down in col A you could use this in say, B1: =COUNTA(A:A)-COUNTIF(A:A,"*"&"ditto"&"*") voila? zonk YES below -- Max Singapore ---
|
|
#5
February 11th, 2010, 11:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count all text values except a certain one
in other works, for the below example, how do i get a count of 4 instead of 8?
"justjill111" wrote: sorry but it returned the entire count. let me be more specific. the names are contained E7:E98 the column looks something like this: jane max ditto ditto ditto laurie kelly ditto does this help? "Max" wrote: One thought .. Assuming your source data running down in col A you could use this in say, B1: =COUNTA(A:A)-COUNTIF(A:A,"*"&"ditto"&"*") voila? zonk YES below -- Max Singapore ---
|
|
#6
February 11th, 2010, 11:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count all text values except a certain one
sorry max, your formula was perfect, i just didn't realize it in time to
avoid making a fool of myself ~!~ "justjill111" wrote: in other works, for the below example, how do i get a count of 4 instead of 8? "justjill111" wrote: sorry but it returned the entire count. let me be more specific. the names are contained E7:E98 the column looks something like this: jane max ditto ditto ditto laurie kelly ditto does this help? "Max" wrote: One thought .. Assuming your source data running down in col A you could use this in say, B1: =COUNTA(A:A)-COUNTIF(A:A,"*"&"ditto"&"*") voila? zonk YES below -- Max Singapore ---
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
