Simple question how do I adjust the for loop to go through the rows of the excel matrix one by one. Milesdriven adds the columns 2:11 of the first row, i want the calculation to be done for the next 54 rows as well.

 filename = 'project3data.xlsx';
 num = xlsread('project3data.xlsx');
 for i = 1:55
       milesdriven = sum(num(2,2:11))
 end

[Walter Roberson]

Duplicates http://www.mathworks.com/matlabcentral/answers/315288-how-do-i-get-i-to-loop-through-the-55-columns-of-the-excel-file-one-by-one-i-want-i-to-correspond-t which is waiting for a response.

Please do not continue to discuss here.

Answer 1

[Tamir Suliman]

 filename = 'project3data.xlsx';
 num = xlsread('project3data.xlsx');

 for i = 1:55
for j =2:11
       milesdriven = sum(num(i,j))
end

 end

[Walter Roberson]

That will not work, that overwrites the answer each time.