How to implement multiple excels with same time horizon?

I have serveal excel sheets with same time horzion. There are some other information(values) in other column. I want to calculate the sum of each column except time horzion. How can I do it?

[Jiexiang Wu]

The sum of each column is total sum of multiple excels in each column.

Answer 1

[Divya Yerraguntla]

Hi Jiexiang,

Have a look at similar question in this link : https://www.mathworks.com/matlabcentral/answers/89176-summing-numerical-data-of-excel-files-in-matlab

Hope it helps!

[Jiexiang Wu]

Thank you for the link. It works well.