| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if does not equal
How do i count the number of cells in a column that do not contain a certain
word or words. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if does not equal
If you want to count the non-blank cells that do not contain a given value,
use =COUNTA(A1:B10)-COUNTIF(A1:B10,C1) This will not count blank cells. If you want to include blank cells in the count, use =(ROWS(A1:B10)*COLUMNS(A1:B10))-COUNTIF(A1:B10,C1) In both formula, change A1:B10 to your actual range of data. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "JRD" wrote in message ... How do i count the number of cells in a column that do not contain a certain word or words. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to count the highest number of equal cells | Excel Worksheet Functions | |||
| Count number of values equal to MAX of a column | Excel Discussion (Misc queries) | |||
| Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
| COUNT IF NOT EQUAL TO ZERO | Excel Worksheet Functions | |||
| Count cells with length not equal to 7 | Excel Worksheet Functions | |||
Linear Mode
