MATLAB: Consolidating counts & sum by Year Range

adding by year ranges

A=[2001 2002 2001 2003 2003 2003 2004 2004 2004 2004 2004 2007;
1 2 3 4 5 6 7 8 9 12 11 12]
I need to know the sum of toys between 2001-2003, 2002-2004, 2005-2007.

Best Answer

y = [2001, 2002, 2005
     2003, 2004, 2007];
 
A = [2001 2002 2001 2003 2003 2003 2004 2004 2004 2004 2004 2007;
        1    2    3    4    5    6    7    8    9   12   11   12]';
  
lo = A(:,1) >= y(1,:) & A(:,1) <= y(2,:);
i = lo.*(1:3);
data = A(:,2).*lo;
out = [y;accumarray(i(lo),data(lo))'];
Related Question