The Macro did not work below is a better description

The Problem is that using formula =SUM(A:B) produces the entire A and B

Colums Total
--Quick Explination --:
We are using Excel as a Data Base that has Top Row Identifiers (First
Name, Amt Owed..etc)

Each line (left to right) is for one specific customer's balance.
There are currently 8,000 different customers.


Our Data reads from Left to Right... our final right field has "Total
Amt Owed" we need a something more simple than having to write
=SUM(A1:B1) for the first customer and then write =SUM(A2:B2) for the
second customer and then white =SUM(A3:B3) and then write this in
incriments for another 7,997