Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct question | Excel Discussion (Misc queries) | |||
A SUMPRODUCT question | Excel Discussion (Misc queries) | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) |