View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevem stevem is offline
external usenet poster
 
Posts: 29
Default Double hyphens --

What does a double hyphen do in a formual?
e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98"))

I saw that as a response in a different post, and I've seen the "--" in
other responses but have not been successful in finding it in help