@Count

M

MAD

I am using Excel 2003.
How do I count rows/column with only text in it. Ex: I have 25 rows where
column "B" says "PO Received" in each cell. I tried @count(B1-B24), but I
only came up with "0" as an answer. What am I doing wrong? Can anyone help
me with this, please???

Aurora
 
T

T. Valko

In Excel formulas are started with an equal = sign.

If you start with the "at" sign Excel will change it to the equal sign.

To count *text only* :

=COUNTIF(B1:B24,"*")

That will include cells that contain formula blanks "". To exclude cells
that contain formula blanks:

=COUNTIF(B1:B24,"?*")
 
J

JLatham

COUNTA() counts both text and numbers
COUNT() counts only numbers, so

=Counta(B1:B24)-Count(B1:B24)
will give you the number of text entries in the range B1:B24

You could also use
=COUNTIF(B1:B24,"PO Received")
and that would count only cells in the range with those words in them.
 

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

Count number of rows with specific text 2
How to Count Strike throughs 1
Count rows based on multiple criteria 3
Count columns that meet criterias 3
How do I count the number of entries of specifc criteria is met 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
use month in cell date to sum all relevant cells 2
Counting Merged Cells 6

Top