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

T

Trixie

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

Bob Phillips

Use

=COUNT(A:A)

and
=COUNTA(A:A)

--

HTH

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

Bob Phillips

Probably

=COUNTIF(Range,"*IBE*")

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to center adjust text above and image in a two column document. 1
Autonumber field in Excel that behaves the same as Access 0
Countif or other formula needed for multiple data/critera results 3
Counting unique instances of a text string 2
Count Number of Unique Cells That Don't Have Certain Characters 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Count number of rows with specific text 2

Top