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. |
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. |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com