Assuming your projections are in A1:A4 and actuals in B1:B4. In C1
enter

=(B1-A1) and copy down to C4. This will return the values (I used your
posted data) of 0,1,-3,-2. In C5 then SUM(C1:C4) which returns the -4.


Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=505016