counting text rows in columns
 

I'm sure there is a way to do this however I"m fairly new to Excel and need
some help.

I have a master list of data on a worksheet and I want to summarize this
data on other "master" sheets. Most of the data is in text format.
I want to specify a formula that looks at the named range on a different
worksheet and counts all records that match "dealer" for instance.

The Count function only seems to work with fields that have a numeric value.
Can someone point me in the right direction?

THanks
Pam

counting text rows in columns
 

"pamlong" wrote in message
...
I'm sure there is a way to do this however I"m fairly new to Excel and
need
some help.

I have a master list of data on a worksheet and I want to summarize this
data on other "master" sheets. Most of the data is in text format.
I want to specify a formula that looks at the named range on a different
worksheet and counts all records that match "dealer" for instance.

The Count function only seems to work with fields that have a numeric
value.
Can someone point me in the right direction?

I think COUNTIF is what you are looking for.

V

counting text rows in columns
 

Try something like this:

Assume your named range is MyRange

=COUNTIF(MyRange,"dealer")

--
Biff
Microsoft Excel MVP


"pamlong" wrote in message
...
I'm sure there is a way to do this however I"m fairly new to Excel and
need
some help.

I have a master list of data on a worksheet and I want to summarize this
data on other "master" sheets. Most of the data is in text format.
I want to specify a formula that looks at the named range on a different
worksheet and counts all records that match "dealer" for instance.

The Count function only seems to work with fields that have a numeric
value.
Can someone point me in the right direction?

THanks
Pam

counting text rows in columns
 

Thank you so much! Does exactly what I was trying to do.


"T. Valko" wrote:

Try something like this:

Assume your named range is MyRange

=COUNTIF(MyRange,"dealer")

--
Biff
Microsoft Excel MVP


"pamlong" wrote in message
...
I'm sure there is a way to do this however I"m fairly new to Excel and
need
some help.

I have a master list of data on a worksheet and I want to summarize this
data on other "master" sheets. Most of the data is in text format.
I want to specify a formula that looks at the named range on a different
worksheet and counts all records that match "dealer" for instance.

The Count function only seems to work with fields that have a numeric
value.
Can someone point me in the right direction?

THanks
Pam

counting text rows in columns
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"pamlong" wrote in message
...
Thank you so much! Does exactly what I was trying to do.


"T. Valko" wrote:

Try something like this:

Assume your named range is MyRange

=COUNTIF(MyRange,"dealer")

--
Biff
Microsoft Excel MVP


"pamlong" wrote in message
...
I'm sure there is a way to do this however I"m fairly new to Excel and
need
some help.

I have a master list of data on a worksheet and I want to summarize
this
data on other "master" sheets. Most of the data is in text format.
I want to specify a formula that looks at the named range on a
different
worksheet and counts all records that match "dealer" for instance.

The Count function only seems to work with fields that have a numeric
value.
Can someone point me in the right direction?

THanks
Pam