Counting Problem

[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 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

[Domenic]

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

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

Hope this helps!

In article <[email protected]>,
peter_rivera
<[email protected]> 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