Count if formula exist

[praveen_khm]

Hello all,

I have a simple problem which is turning wild for me. I need to count
the number of cells in a column with value 1. The range contains
formulas. Now when I give a countif of sumif or even count, it takes
the 1 which exists in the formula also. Suppose,
=SUMPRODUCT(($Q21>0)*($E21="completed")) is the formula given, it takes
the 1 in the formula also. Please let me know what do I do to take only
the value.

Thanks.
Praveen

 

[Bob Phillips]

That formula counts the instance where Q21 is greater than 0, not equal to
1, and E21 = completed. It doesn't count a column, or many rows, just the
single instance. It can also be written simpler as

=($Q21>0)*($E21="completed")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"praveen_khm" <[email protected]>
wrote in message
news[email protected]...