Hello Ryevick,

Make the following changes to your Workheet

P29 =IF(SUM(P24:P28)40, "40", SUM(P24:P28))
P41 =IF(SUM(P36:P40)40,"40",SUM(P36:P40))

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=486316