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

[Huggy]

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

 

[Pecoflyer]

I have been given a spreadsheet that works with the following formul
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

Hi,
http://www.xldynamic.com/source/xld.SUMPRODUCT.html#classic will giv
you perfect inf

--
Pecoflye

Cheers -

Firefox 3.5.3 is as slow as possible

 

[Jacob Skaria]

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 here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

If this post helps click Yes