SUMPRODUCT question

[Conan Kelly]

Hello all,

Every response that I've seen that includes SUMPRODUCT, I see all of the
experts using the "Binary Negetion Operator" (<---please correct my
terminology if incorrect). For example: =SUMPRODUCT(--([Some Range
=,<,>,<=,>= Some value or some cell ref]),--([Some Range]))

What is the purpose of the "Binary Negetion Operator"?

I've been the SUMPRODUCT function for a year or so now and have never used
the the double negative. Although, I do use the function in the other
manner: =SUMPRODUCT(([Some Range =,<,>,<=,>= Some Value or Some Cell
Ref])*([Some Range]))

Thanks for any help anyone can provide,

Conan Kelly

 

[Bill Kuunders]

Have a look at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

this gives a very detailed explanation on all aspects of the sumproduct
formula.

Greetings from New Zealand