Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing two columns
I have reports that have one group of totals in one column and another group
of totals in another column. I would like to add another column that gives the difference for each row. The reports have various numbers of rows and I would like to also have a count of the number of rows of difference. Row 1 has 350 in column e and 570 in column h. I want the difference between column e and h in column j. Row 2 has 230 in column e and 120 in column h. I want the difference between column e and h in column j. Row 3 has 479 in column e and 443 in column h. I want the difference between column e and h in column j. Then I want cell K1 to give a sum of column j. Then I want cell L1 to count how many rows have a difference. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing across columns while skipping some columns | Excel Worksheet Functions | |||
Summing columns | Excel Discussion (Misc queries) | |||
Summing two columns | Excel Programming | |||
summing columns | Excel Worksheet Functions | |||
Summing Columns | Excel Worksheet Functions |