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.