Counting NUMBERS &/or TEXT from a column to other sheet ?
 

I am working with a workbook that contains two sheets. I need to count (all
in the same column) in one case a number/text combo (EXE & 000).

In the next case I need to count only text (from same column as above!). I
am a novice & thought simply using the "COUNT" would do it but have been at
it for about an hour & cannot figure it out!!!

Please help!

Use

=COUNT(A:A)

and
=COUNTA(A:A)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Trixie" wrote in message
...
I am working with a workbook that contains two sheets. I need to count
(all
in the same column) in one case a number/text combo (EXE & 000).

In the next case I need to count only text (from same column as above!).
I
am a novice & thought simply using the "COUNT" would do it but have been
at
it for about an hour & cannot figure it out!!!

Please help!

The only text I need to count in the second scenario is "IBE".

"Trixie" wrote:

I am working with a workbook that contains two sheets. I need to count (all
in the same column) in one case a number/text combo (EXE & 000).

In the next case I need to count only text (from same column as above!). I
am a novice & thought simply using the "COUNT" would do it but have been at
it for about an hour & cannot figure it out!!!

Please help!

=COUNTIF(Range,"IBE")

--

Regards,

Peo Sjoblom

"Trixie" wrote in message
...
The only text I need to count in the second scenario is "IBE".

"Trixie" wrote:

I am working with a workbook that contains two sheets. I need to count
(all
in the same column) in one case a number/text combo (EXE & 000).

In the next case I need to count only text (from same column as above!).
I
am a novice & thought simply using the "COUNT" would do it but have been
at
it for about an hour & cannot figure it out!!!

Please help!

Probably

=COUNTIF(Range,"*IBE*")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peo Sjoblom" wrote in message
...
=COUNTIF(Range,"IBE")

--

Regards,

Peo Sjoblom

"Trixie" wrote in message
...
The only text I need to count in the second scenario is "IBE".

"Trixie" wrote:

I am working with a workbook that contains two sheets. I need to
count
(all
in the same column) in one case a number/text combo (EXE & 000).

In the next case I need to count only text (from same column as
above!).
I
am a novice & thought simply using the "COUNT" would do it but have
been
at
it for about an hour & cannot figure it out!!!

Please help!