How to read multiple cells in excel?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
Antworten (1)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!