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?

=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?
>
>
>
>
>
>
>.
>

thanks Jason that has solved the COUNTIF problem, but it does not seem to
work for COUNTA?


"Jason Morin" <[email protected]> wrote in message
news:[email protected]...
> =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?
>>
>>
>>
>>
>>
>>
>>.
>>