You're welcome Stuart.............to count everything,

=COUNTA(A:A)

To count everything EXCEPT "sales"........

=COUNTA(A:A)-COUNTIF(A:A,"SALES")


Vaya con Dios,
Chuck, CABGx3


"Stuart" wrote in message
...
Thanks CLR, that did the trick.

Is there a function that will count ALL values in the range i.e.
SALES = 3
IT = 1
HR = 1
FINANCE = 1

Thanks.

"CLR" wrote:

=COUNTIF(A:A,"sales")

Vaya con Dios,
Chuck, CABGx3


"Stuart" wrote in message
...
I want to count a specific data item from a range e.g. say the data
below
was
in column A and B on a spreadsheet:

Department Name
SALES John
SALES Fred
IT Sue
FINANCE Stu
SALES Jo
HR Steve

I want to count the number of times SALES occurs. I've tried
DCOUNT/DCOUNTA
but haven't got this to work. Any help appreciated!