Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTA IF(NOT)
Is it possible to count a cell if the cell is NOT a particular value? I
have a workbook where i am trying to count the number of cells that don't have the text "despatched" in them. I can get it to work, but not with a wildcard* and I need to use a wildcard* in the logic. any ideas anyone? |
#2
|
|||
|
|||
=COUNTIF(A1:A10,"<*despatched*")
HTH Jason Atlanta, GA, USA -----Original Message----- Is it possible to count a cell if the cell is NOT a particular value? I have a workbook where i am trying to count the number of cells that don't have the text "despatched" in them. I can get it to work, but not with a wildcard* and I need to use a wildcard* in the logic. any ideas anyone? . |
#3
|
|||
|
|||
thanks Jason that has solved the COUNTIF problem, but it does not seem to
work for COUNTA? "Jason Morin" wrote in message ... =COUNTIF(A1:A10,"<*despatched*") HTH Jason Atlanta, GA, USA -----Original Message----- Is it possible to count a cell if the cell is NOT a particular value? I have a workbook where i am trying to count the number of cells that don't have the text "despatched" in them. I can get it to work, but not with a wildcard* and I need to use a wildcard* in the logic. any ideas anyone? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTA, COUNTIF? | Excel Worksheet Functions | |||
Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
Problems copying cells using offset and counta | Excel Discussion (Misc queries) | |||
counta | Excel Worksheet Functions | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |