Thanks, Gord. That's a great tip.
--
Sincerely, Michael Colvin


"Gord Dibben" wrote:

Sam

Enter your =SUM(A1:B1) in C1

Double-click on the fill handle of C1 which will copy the formula down column C
incrementing as it goes.


Gord Dibben MS Excel MVP

On 26 Oct 2006 09:55:54 -0700, "Sam" wrote:

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


Thanks in advance
Jenny the Excell Newbee