View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] s.b.bhor@gmail.com is offline
external usenet poster
 
Posts: 1
Default What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke

Consider the formulae =SUMPRODUCT(--(A1:A10="Luke Skywalker"),--(B1:B10="West"),D1:D10)

What does -- mean in front of --(A1:A10="Luke Skywalker")
and --(B1:B10="West")