Hi, I am using the following formula (which I learned on this site yesterday - big thanks) to copy text:
=IF('Registration '!G63="Parent",'Registration '!B63,"")
Now I want to be able to count the cells containing text in the worksheet that I have copied to (i.e. cells containing parent's last names). How do I count cells with text only, not cells containing the formula? Thanks.
that formula will leave an "empty" cell if there is no "Parent", so you should be able to use =countA()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
On the worksheet that the names are copied to, =countA is counting the cells that contain the formula (in other words, all of the cells).
Is there a way of counting cells that contain text (parent's names) but not counting cells that contain numbers (formula)?
A formula blank is considered a TEXT entry.
This will count all cells that contain a text entry but will exclude cells that contain formula blanks:
=COUNTIF(A1:A10,"?*")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
hmm my brain has gone blank. For the time being, use this...until I can think of a better way...
=COUNTA(A1:A9)-COUNTBLANK(A1:A9)
That works. Thanks.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks