Counting only user defined cells if it contains a string (# & text

R

rex

I'd like to thank everyone in advance for replying to this question.

Hi, I'd like to get an assistance in resolving this problem. Im tryin to
find out how could I count a user defined cells (6 rows) containing a string
(ex. 2435 Smith Dr) using a formula. Currently, I'm just entering the count
manually and I know there's a solution how to automate the counting. If the
cell is empty the value shold be returned for that cell must be 0 and if its
contain the string, its value must be 1..This is how I'm approacing it but it
doesn't work using the IF function....Thanks!
 
D

David Parker

Perhaps you should have an empty string "" as the default, then you can use
IF(STRSAME(User.MyCell,""),0,0)
 

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

User Defined Cells counting 2
Word macro that can call cells out of Excel for a find and replace 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Counting User Defined Cells 2
Searching the formula (not the value) for a text string 1
Fixing text wrap in merged cells 1
How to count empty and filled user defined cells? 1
A way to count cells in a range containing text or formulas 3

Top