@Count
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,"?*")
--
Biff
Microsoft Excel MVP
"MAD" wrote in message
...
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
|