Counting data in a range

[Guest]

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!

 

[CLR]

=COUNTIF(A:A,"sales")

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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.

 

[Damon Longworth]

To count all, try Count or CountA.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com

 

[CLR]

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