I have a row of 1308 values and I need the total every 12 rows. So I need the sum of rows 1-12 and then again for the next 12 numbers

1

1

1

5

5

1

1

1

10

1

1

1

so basically I need the sum of all these numbers in this entire column for the 12 rows and then i need to get the values for the next 12 rows

Answer 1

[chemPolonium]

Maybe you can use reshape and sum function.

For example:

a = rand(1, 1000); % this create a rand vector of 1000 dims

b = reshape(a, 10, 100); % this convert vector a to a matrix of 10 rows and 100 columns

c = sum(b); % this calculate the sum of each column

[Megan Mirkhanian]

b = reshape(Excel, 12, 109); % this convert vector a to a matrix of 10 rows and 100 columns

c = sum(b); % this calculate the sum of each column

it tells me

Error using reshape

To RESHAPE the number of elements must not change.

Error in Untitled2 (line 23)

b = reshape(Excel, 12, 109);

[chemPolonium]

This error occurs when the numbers of elements are not equal for reshaped and origin matrix. You can check the size of the origin matrix (in your program I think it's Excel) by using numel or size function.

[Walter Roberson]

What shows up for

size(Excel)

[Megan Mirkhanian]

You all are amazing! Thank youuuu