Jeff wrote:
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.



One approach which works is:

={SUM(IF(D4:D100=TRUE,1,0))}

Note that this is an array formula, so when you've typed it in you have to hit
Shift-Ctrl-Enter.

Bill