Thread: Double Dash
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Erin Searfoss Erin Searfoss is offline
external usenet poster
 
Posts: 41
Default Double Dash

What does the double dash signify in a formula like this one I found in a
2006 post?

=SUMPRODUCT(--(X2:X500="foo"),--(Y2:Y500<100))

I've seen it muliple times and haven't quite figured it out. Thanks.