calculate area in table

Greetings,

I have a 32 variables containing 1000++ rows and a column containing area for each row. Can Matlab read and call a certain variable in the row and calculate area based on selected variable?

Answer 1

[Andrei Bobrov]

T = readtable('Book1.xlsx');
out = varfun(@sum,T,'g','Class_Name');

[nur afiqah]

Thank you for the answer, I've reffered to the function varfun and managed to get the answer.

What if we have multiple argument? (e.g.: total area for each class at specific distance provided) I attached the file for your perusal.

Your answer is very much appeciated!

[Andrei Bobrov]

T = readtable('Book2.xlsx');
out = varfun(@sum,T,'g',{'Class_Name','distance'});

Answer 2

[KSSV]

Load the data from excel file using xlsread or readtable. Once you have data in workspace......you can get your desired result using some functions and indexing.