Sum of Cell Array [Besides for loop]

4 views (last 30 days)
I'm having difficulty trying to solve this problem. Suppose:
testvalue = {[1] [] []
[1] [1] [1]
[1] [] []
[1] [1] []}
I want to sum the contents of each row, which should give:
1+nil+nil=1
1+1+1=3
1+nil+nil=1
1+1+nil=1
I tried using for loop but it upon adding cumulative sum with [], the new sum becomes []. Can someone shed some light? Thanks.

Accepted Answer

Walter Roberson
Walter Roberson on 15 Apr 2013
T = testvalue;
T(cellfun(@isempty,T)) = {0};
sum( cell2mat(T), 2)
  2 Comments
RDG
RDG on 15 Apr 2013
Elegant solution. Thank you!
Eduardo Gil
Eduardo Gil on 2 Sep 2020
Brilliant. However, could Matlab be any more cumbersome when it comes to the simple stuff. A spreadsheet would have done this without any need for logic. On the other hand, Matlab is so powerful for other less mundane tasks.

Sign in to comment.

More Answers (0)

Categories

Find more on Environment and Settings 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!