View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LPS
 
Posts: n/a
Default Dashes in Functions

Has anyone ever seen the use of "dashes" in functions or formulas before? I
have a user who has several instances where dashes have been used (someone
sent her the spreadsheet) and none of us have ever seen this before. An
example follows:

=SUMPRODUCT(--(F3:F838<121),--(E3:E838=1))

Any suggestions / explanations?
Thanks,
--
LPS