Jesse,

Looks like you could use an "IF Then" Formula. You may know this but
just in case... An IF Then Formula will return one condition if
certain cells meet, or are true, to a set caritia or another result if
those same cells do not meet that caritia, or are false.

The formula below will do the following actions.

If the sum of K10 through K23 is greater than 70...it will Sum up that
range and then subtract 70. This will give you the amount over 70.
However if the range K10 through K23 is less than 70 a ZERO value will
be shown.

=IF(SUM(K10:K23)70,SUM(K10:K23)-70,0)

If you like you can also choose to hide ZERO values. This way if a cell
equals ZERO then it appears blank. Only when it is greater than ZERO
will it show a value.
To do this select [TOOLS][OPTIONS][VIEW TAB] Check Hide zero Values.


Hope this will work for you


--
JasonCrimmel
------------------------------------------------------------------------
JasonCrimmel's Profile: http://www.excelforum.com/member.php...o&userid=25638
View this thread: http://www.excelforum.com/showthread...hreadid=390465