View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
fodman
 
Posts: n/a
Default Totalling discrepancies


Hello all,

help much appreciated on the following problem:

Column A contains "Expected number of units"

Column B contains "Actual number of units"

Column C contains "Difference"



Expected Actual Diff
2 3 1
-1 5 6
8 1 -7



What i need is for the sum of Column C (diff) to give me 14, as there
are 14 discrepancies shown.


Thanks in advance.


--
fodman
------------------------------------------------------------------------
fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941
View this thread: http://www.excelforum.com/showthread...hreadid=552422