calculate average column in multiple files

1 次查看（过去 30 天）
viet le
viet le 2019-1-16
编辑： viet le 2019-1-17
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)

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

采纳的回答

madhan ravi
madhan ravi 2019-1-16

更多回答（0 个）

类别

在 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