| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting cells that don't contain certain text
Is there a quick and easy way of counting the number of cells that don't
contain certain text strings For example Column A Yes No Yes Maybe Maybe No Certainly Definately Yes How could I count the number of cells that don't contain the word "yes" - in this case the answer would be 6 Many thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting cells that don't contain certain text
See if this does the trick.
=COUNTA(A1:A9)-COUNTIF(A1:A9,"Yes") "JRD" wrote: Is there a quick and easy way of counting the number of cells that don't contain certain text strings For example Column A Yes No Yes Maybe Maybe No Certainly Definately Yes How could I count the number of cells that don't contain the word "yes" - in this case the answer would be 6 Many thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting cells that don't contain certain text
Hi!
Try this: =COUNTIF(A1:A9,"<yes") That will include empty and blank cells. If you want to exclude empty/blank cells: =SUMPRODUCT(--(A1:A9<""),--(A1:A9<"yes")) Biff "JRD" wrote in message ... Is there a quick and easy way of counting the number of cells that don't contain certain text strings For example Column A Yes No Yes Maybe Maybe No Certainly Definately Yes How could I count the number of cells that don't contain the word "yes" - in this case the answer would be 6 Many thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting cells that don't contain certain text
or if all cells are filled and j9 is the last cell with data
=COUNTIF(J1:J9,"<yes") -- Don Guillett SalesAid Software "JRD" wrote in message ... Is there a quick and easy way of counting the number of cells that don't contain certain text strings For example Column A Yes No Yes Maybe Maybe No Certainly Definately Yes How could I count the number of cells that don't contain the word "yes" - in this case the answer would be 6 Many thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting cells that don't contain certain text
Try...
=COUNTIF(A2:A10,"?*")-COUNTIF(A2:A10,"Yes") Hope this helps! In article , JRD wrote: Is there a quick and easy way of counting the number of cells that don't contain certain text strings For example Column A Yes No Yes Maybe Maybe No Certainly Definately Yes How could I count the number of cells that don't contain the word "yes" - in this case the answer would be 6 Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set a number number value as text in all cells ? | Excel Worksheet Functions | |||
| getting a total for a row of cells where some are text | Excel Discussion (Misc queries) | |||
| Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Excel - counting cells containing a text string | Excel Worksheet Functions | |||
Linear Mode
