Counting Problem
 

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 a
letter/value, then formula will return a result of 1. The cells, which
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 count
those cells which have a blank result. Is there anyway to do this in
Excel?

Thanks and Have a great weekend,
Pete


--
peter_rivera
------------------------------------------------------------------------
peter_rivera's Profile: http://www.excelforum.com/member.php...o&userid=24495
View this thread: http://www.excelforum.com/showthread...hreadid=468343

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

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

Hope this helps!

In article ,
peter_rivera
wrote:

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 a
letter/value, then formula will return a result of 1. The cells, which
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 count
those cells which have a blank result. Is there anyway to do this in
Excel?

Thanks and Have a great weekend,
Pete