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