View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JoAnn JoAnn is offline
external usenet poster
 
Posts: 78
Default Meaning of "--" in formulas

I sometimes see formulas with -- before a set of parenthesis (sample formula
below), can anyone tell me what the purpose of it is? I can't seem to find
it documented anywhere.

For example:
=SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417)), --(YEAR(b7:b400)=YEAR(D417))

Thanks
--
JoAnn