I have a delimted text file that I need to import into excel sort it by
product number and total sales by product. I have to do this twice a month so
I made a marco that imports the file and then using filter it filters by
product number and copies the resuts to another sheet in the workbook.

The trouble Im having is that I don't know how to add the entire column for
total sales automatically. the total sales will always be in column C but the
row number will always be different.

I have tried highlighting the C column and clicking on the sum icon in the
toolbar but it doesn't give me a total at the bottm of the column.

Is there a way to have excel give me the sum at the bottom of the column if
the row number is different everytime?

Thanks

Jem

The cells are formatted as text and look like numbers but are not.

Format all to General then copy an unused cell.

Select the data range and EditPaste Special(in place)AddOKEsc.

This usually coerces them to numbers.

Then I would place my SUM formula at the top of the column.

=SUM(C:C)


Gord Dibben MS Excel MVP

On Wed, 7 Feb 2007 11:04:01 -0800, JEM wrote:

I have a delimted text file that I need to import into excel sort it by
product number and total sales by product. I have to do this twice a month so
I made a marco that imports the file and then using filter it filters by
product number and copies the resuts to another sheet in the workbook.

The trouble Im having is that I don't know how to add the entire column for
total sales automatically. the total sales will always be in column C but the
row number will always be different.

I have tried highlighting the C column and clicking on the sum icon in the
toolbar but it doesn't give me a total at the bottm of the column.

Is there a way to have excel give me the sum at the bottom of the column if
the row number is different everytime?

Thanks