Is this it?

=IF(L7L6,(IF(SUM(K1:K5)=30,SUM(K1:K5)-30,IF(SUM(K1:K5)=20,SUM(K1:K5)-20,IF(SUM(K1:K5)=10,SUM(K1:K5)-10,IF(SUM(K1:K5)<10,SUM(K1:K5))))))-1,IF(SUM(K1:K5)=30,SUM(K1:K5)-30,IF(SUM(K1:K5)=20,SUM(K1:K5)-20,IF(SUM(K1:K5)=10,SUM(K1:K5)-10,IF(SUM(K1:K5)<10,SUM(K1:K5))))))


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=398300