Not sure what this syntax "--" means in this formula:
SUMPRODUCT(--(A1:A6<0),B1:B6,A1:A6)/(SUMPRODUCT(--(A1:A6<0)))

Does this weight by the balances in column B?


--
jeffsfas
------------------------------------------------------------------------
jeffsfas's Profile: http://www.excelforum.com/member.php...o&userid=24462
View this thread: http://www.excelforum.com/showthread...hreadid=380573