Summing "False" and "True"
I have an equality -
Cell A1 "=B1C1"
The value is true since cell B1=10 and C1=3
This repeats down to row 100. A2, A3, ...A100
I want to sum up the number of True statements. I use
Sumproduct((A1:A100=1)*1),
But this equals zero. Why doesn't this add 1 when the value is true. Isn't
the value of cell A1 = 1 since the result is a true statement.
|