Thanks everyone for all the help. I'm not an Excel expert but these
formulas seemed to work for me in calculating what I needed:

Array formula
{=SUMPRODUCT(IF(a1:a6<0,(b1:b6)*(a1:a6)))/SUM(IF(a1:a6<0,b1:b6))}

Does not need to be an array formula
=SUMPRODUCT(--(a1:a6<0),b1:b6,a1:a6)/(SUMPRODUCT(--(a1:a6<0),b1:b6))

This seems to work because I need to weight by what is in column B. I
think I copied these formulas into the new thread correctly. There may
be a better way to write this but these seem to work for now. I should
try this out on more than a few examples. Back to crunching numbers.


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