How do logicals be added or multiplied?

[dindigul]

Hello
The following does work, but how is the question.
=SUMPRODUCT((range_a < c3)*(range_b>=c9))
When input individually i.e. =(range_a<c3) produces either TRUE or FALSE and
same thing for =(range_b>=c9). But as a whole it does produce values like
1,2 ... What is happening? Any ideas?
Thanks

 

[AKphidelt]

Because the the formula is saying when using an *

How many times is this event TRUE...

So in your formula it just counts up the number of times range_a is less
then c3 and range b> c9

So since it's just referring to one combination, if both values are true...
it will add it up to 1. If one of the arguments is false, it will be 0.

When you just do range_b > c9 its just saying... is it or is it not TRUE

 

[Stan Brown]

Hello
The following does work, but how is the question.
=SUMPRODUCT((range_a < c3)*(range_b>=c9))
When input individually i.e. =(range_a<c3) produces either TRUE or FALSE and
same thing for =(range_b>=c9). But as a whole it does produce values like
1,2 ... What is happening? Any ideas?

TRUE translates to 1, and FALSE to 0.

For much, much more:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html