| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum hours and minutes totalling over 24 hours? | Excel Worksheet Functions | |||
| Totalling numbers that are Conditionally Formatted | Excel Discussion (Misc queries) | |||
| Totalling lists | Excel Discussion (Misc queries) | |||
| Totalling unique values | Excel Discussion (Misc queries) | |||
| Totalling workbooks | New Users to Excel | |||
Threaded Mode
