View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default 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.