Sum up data from various excel files in different folders
2 views (last 30 days)
Show older comments
Commented: Vlatko Milic on 4 Jan 2018
Hi, I am quite new to Matlab and have a question for you experts :) I want to sum up specific rows in a certain column in different excel-files located in various folders. The search path is attached (see matlab.jpg) where Matlab_Esignatur is the home location, "eltest" contains different addresses (such as Berzeliigatan 14) that are folders, and within each adress there are a number of excel-files. The no. of excel-files differs from each adress/folders. The excel-files are also attached. I only want to sum up the value of certain rows in column G with the column value of 1, and not 2, in column A (see matlab2.jpg).
What I have managed so far is to read the different street names or folders, see matlab3.jpg, where the code is also seen. What is my next step?
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!