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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing two columns
Assuming Excel 2003 or lower:
Column J would have formulas such as... In Cell J1: =+H1-E1 In Cell K1: =SUM(J:J) In Cell L1: =SUMPRODUCT(--(J1:J65535<0)) -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "jsherry47" wrote: 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. |
Reply |
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 |