Thread: What does "--" (2 minus signs) do in a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Huggy Huggy is offline
external usenet poster
  
Posts: 14
Default What does "--" (2 minus signs) do in a formula
I have been given a spreadsheet that works with the following formula included.

SUMPRODUCT(--(INT((MONTH(ROW(INDIRECT($K4&":"&$J4)))+2)/3)=3),--(YEAR(ROW(INDIRECT($K4&":"&$J4)))=YEAR(Q1Start))))

What does the "--" 2 minus signs after sumproduct do?

Thanks
Reply With QuoteReply With Quote