Thread: Double Dash
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Double Dash
It converts a logical value (TRUE or FALSE) into a numerical value (1 or 0)
--
Gary''s Student - gsnu200860


"Erin Searfoss" wrote:

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.
Reply With QuoteReply With Quote