count visible cells only

[already]

Hi

I have a range that returns (lookup) data (text).
I want to count only the cells that returns visible text in this range and not the cells with formulas. (the range is not filtered !)

How can I do this?

Thanks in advance

Kind regards

Al

 

[Peter_SSs]

I assume that means you want to avoid counting cells that have null strings ("") returned by their formulas?

Are the formulas that return other than "", returning numbers, text or possibly either?

What is the range?

 

[Aladin Akyurek]

Try one of...

=COUNT(Range)+COUNTIF(Range,"?*")
 
=SUMPRODUCT(1-(Range=""))

The first formula can be reduced to...

=COUNTIF(Range,"?*")

if the look up formula is not expected to return any number.

 

[already]

Thanks both of you.

the formula =COUNTIF(Range,"?*") did the job

Have a nice WE

Al

 

[Aladin Akyurek]

Thanks both of you.

the formula =COUNTIF(Range,"?*") did the job

Have a nice WE

Al

You are welcome. Thanks for providing us feedback.