Adding multiple elements from an array

1 次查看（过去 30 天）
Nihal Paul
Nihal Paul 2016-4-9
回答： Roger Stafford 2016-4-10
I have an 8*8 table in an excel file
A
To/From 1 2 3 4 5 6 7 8
1 0.1179 0 0 0 0 0 0 0
2 0.053 0.1949 0 0 0 0 0 0
3 0.0301 0.1159 0.5868 0 0 0 0 0
4 0.0001 0.0005 0.0769 0.8234 0 0 0 0
5 0 0 0.0019 0.1961 0.818 0 0 0
6 0 0 0 0.005 0.1737 0.6902 0.0023 0
7 0 0 0 0.0007 0.0246 0.2707 0.8626 0.0275
8 0 0 0 0.0001 0.0073 0.055 0.3589 1.9761
I wanted to know how I can add all the elements in column 1 except the element (1,1). Similarly, how I can add all the elements in column 2 except (2,2), and so on.
PS: I know how to select the data I need for the first column with xlsread.
eg.
s1=xlsread(filename,1,'B4:B10');
But I don't know how to read data from column 2 without selecting element(2,2). And how to add them.

请先登录，再回答此问题。

回答（2 个）

Azzi Abdelmalek
Azzi Abdelmalek 2016-4-9
You have 8x8 matrice, then read it from excel, then do whatever you want.
Roger Stafford
Roger Stafford 2016-4-10
A(1:9:55) = 0;
v = sum(A,1);

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by