Counting Problem

P

peter_rivera

Hi everyone,

My problem is with the COUNTA funciton. I have a formula
"=IF(COUNTA(K4:Q4)>0,1,0)", set up so that if at least one cell has
letter/value, then formula will return a result of 1. The cells, whic
this equation counts, are also formulas as well. (Ex
=IF('Protocol!$K4="","",'Protoco !$K4))

I want to be able to count the cells that have data, yet not coun
those cells which have a blank result. Is there anyway to do this i
Excel?

Thanks and Have a great weekend,
Pet
 
D

Domenic

Assuming that your data contains text values and/or formula blanks,
try...

=IF(COUNTIF(K4:Q4,"?*"),1,0)

Hope this helps!

peter_rivera
 
Top