Counting data in a range

[Stuart]

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


"Stuart" <[email protected]> wrote in message
news:[email protected]...
> 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!

[Stuart]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

[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


"Stuart" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> >
> >
> >