View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default 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