Thank you so much! That did the trick.

"goober" wrote:


=SUM(8-(G10+M10+N10+O10+P10+Q10+R10+S10+T10+U10))
Should do what you want.


=SUM(8-SUM(G10,M10:U10))
Does the same thing only using arrays.

This will also give you a negative if the numbers entered exceed 8.

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=485937