| Home |
| Search |
| Today's Posts |
|
#6
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...? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Text Values | Excel Worksheet Functions | |||
| using =COUNTIF to count two text values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count bold text values | Excel Worksheet Functions | |||
| Count how many different text values in an array. | Excel Worksheet Functions | |||
Threaded Mode
