Sum at end of column question

[Guest]

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

 

[Gord Dibben]

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 Edit>Paste Special(in place)>Add>OK>Esc.

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