清空筛选条件
清空筛选条件

How to read multiple cells in excel?

6 次查看（过去 30 天）
Mary Ng
Mary Ng 2015-12-5
评论： Walter Roberson 2015-12-5
I would like to read multiple cells in excel, for example:
I want the average of the values between A1:A50 A60:100. (So ideally 90 cells in total)
I've tried;
x = xlsread('filename','A1:A50, A60:90'); (THIS AND THE THE ONE BELOW, GIVES ME TWO DIFFERENT ANSWERS. SO CONFUSED.)
x = xlsread('filename','A60:A90, A1:A50); (DIFFERENT ANSWER TO THE ONE ABOVE, WHY??)
x = xlsread('filename','A60:A50'); (100 is the last cell and this gave me a completely different answer.)
And sooo many more.
I know it's not correct because I've already calculated the average manually, and it does not match the one above.
I've attached photo to show what I want. The 183.564 is the sum of all the variables. But when I tried to do it on matlab, it doesn't give me the answer I want. Only on excel it seems to work.
Sorry if I'm not clear, and thank you!

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

回答（1 个）

Walter Roberson
Walter Roberson 2015-12-5
  2 个评论
Mary Ng
Mary Ng 2015-12-5
编辑：Walter Roberson 2015-12-5
So.. something like this?
x1 = xlsread('filename','A1:A50');
x2 = xlsread('filename', 'A60:100');
x = (x1 + x2);
I've tried and it still isn't giving me what I want.. :/
sorry, I've attached the photo now.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by