calculate average column in multiple files

1 view (last 30 days)
viet le
viet le on 16 Jan 2019
Edited: viet le on 17 Jan 2019
I have 10 .xls files (name file1.xls, file2.xls...) in a folder, each has 10 columns (Ai, Bi, Ci,...). Now I want to create one .xls file that calculate average of column A, B, C... (A=A1+A2+...+A10/10); (B=B1+B2+...+B10)......
A1, A2, A3 ... A10 have various length as well as Bi, Ci, Di......
example (attached)

Sign in to answer this question.

Accepted Answer

madhan ravi
madhan ravi on 16 Jan 2019
  1 Comment
viet le
viet le on 16 Jan 2019
Edited: viet le on 16 Jan 2019
thanks. but I was wondering how to import just one column

Sign in to comment.

More Answers (0)

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!