Note that your formula does not work if any of the cells are blank, another
way would be

=SUM(D15,F18,G10)/SUMPRODUCT(N(LARGE((D15,F18,G10),ROW(INDIRECT("1:" &COUNT(D
15,F18,G10))))<0))

entered normally

--

Regards,

Peo Sjoblom

"Krishnakumar"
wrote in message
news:Krishnakumar.20heay_1135321881.0492@excelforu m-nospam.com...

Hi,


Another option..

Try,


=SUMPRODUCT(SUMIF(INDIRECT({"D15","F18","G10"}),"< 0",INDIRECT({"D15","F18",
"G10"})))/SUMPRODUCT(COUNTIF(INDIRECT({"D15","F18","G10"})," <0"))

Normal enter.

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=495468