Thanks Dave,

I wanted to thank you for your help. The calculation worked but it was the
opposite answer that came up when I entered the equation that I needed. I
look forward to working with you in the very near future.

"davesexcel" wrote:


Graham Moran Wrote:
....difference between a set number, 1400,
and the total calculation of a column, anywhere between 1200 and 2000.
I
need to know how to create a calculation to show the numeric difference
from
the 1400 both positive and negative. Any and all help would be
greatly
appreciated.
here's an example say Range A1:A20 has your values
in B1 enter this formula
=1400-sum(A1:A20)


--
davesexcel


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