Counting data in a range
 

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!

=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!

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!

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


"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!

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!