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

What does "--" (2 minus signs) do in a formula
 

It is called "double unary minus" and J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

If this post helps click Yes
---------------
Jacob Skaria


"Huggy" wrote:

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