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.

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.