Thanks daddtlonglegs,

Your equation worked perfectly and gave me the answer I needed. Hope to
work with you in the future when I need more help.

"daddylonglegs" wrote:


Try something like

=SUM(a1:a100)-1400


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537583