User Defined Cells counting

[rex]

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
entering the count manually and I know there's a solution how to automate the
counting. If the cell is empty the value to be returned for that cell must
be 0 and if it contain the string, its value is = 1..This is how I'm
approacing it but it doesn't work using the IF function....Thanks

 

[Mark Nelson [MS]]

I'm not sure what you are trying to do, but you might look at the
FormulaExists function.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Paul Herber]

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
entering the count manually and I know there's a solution how to automate the
counting. If the cell is empty the value to be returned for that cell must
be 0 and if it contain the string, its value is = 1..This is how I'm
approacing it but it doesn't work using the IF function....Thanks

I've put an example for 2 cells at:
http://www.sandrila.co.uk/countOfNonEmptyStrings.zip
and it displays the count as a text field within the shape itself.

Extension for 6 cells is left as an exercise.

P.S. you only need to post once. Now you've 6 message threads to
check!