MATLAB: How adding multiples values insiade Excel file

mathematicsMATLAB

hi , i have multi excel files contains multiple values, i need adding the values for each variable which is repeated much time inside the Excel file as in the code below, Please
the variable: sim_ticks have multi vales inside the Excel file , i need adding all these values together ! 
 xlfiles = dir('*.xlsx'); % You are in the folder of xl files
      Nfiles = length(xlfiles) ;  % number of xl files
        % loop for each file 
    for i = 1:Nfiles
      fname = xlfiles(i).name ;   % file name
             [~,~,dat] = xlsread(fname) ;   % read the file 
             p= strcmp(dat(:,1),'sim_ticks') ;           %# 1- Find the value of  sim_ticks 
        
             
             simtickx(i) = sum( cell2mat(dat(p,2));   % this summing values gave me error !!!
    
        ca{i, 1} = simtickx(i); 
      end
    col_header={'Total Ticks'};     %Row cell array (for column labels)
     
       xlswrite('SRAMBLACkholes.xlsx',col_header,'Sheet1','A1');     %Write column header
            
      cellReference = sprintf('A2');
     xlswrite('SRAMBLACkholes.xlsx', ca, 'Sheet1', cellReference); % Write out ca, not data.
Error: File: test1.m Line: 11 Column: 51
Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for mismatched
delimiters.

Best Answer

thanks a lot for your help.
Related Question