SUMPRODUCT question
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
|