combining column data

[kerrysr]

Hello;

I have a spreadsheet with hundreds of customers. Each row contains the cust. name, address, and then sales history which takes up 8 columns. I.e. sales for period one is on row 1, column 1, sales in period 2 is row 1 column 2, etc.

I need the columns (all 8) added up (TOTAL) for each row/customer.

What is the easiest way to do this?

Thanks

 

[jimbojones]

Hi,

Am I missing something here???

So col A = Cust Name
Col B = Address
Col C = Period 1 sales
Col D = period 2 sales
...
Col J = Period 8 sales


After your 8 columns of sales ie in column K just use =SUM(C1:J1) copy down and total at the bottom?

James

 

[kerrysr]

empty rows not removed

Hi;

I have a large spreadsheet that has many empty rows. When I use ASAP to remove empty rows, it goes through the motion but all the empty rows are still there. Could there be some hidden data in the rows that it cant see"

Thks

 

[jimbojones]

Hi,

It is possible that there are rows which are not trully null fields. i.e. they have spaces contained in them.

Check some of the unremoved lines for spaces by hitting F2 and moving cursor left and right to see if spaces exist.

Any help?

James