How adding multiples values insiade Excel file ?

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.

Answer 1

[Furat Alobaidy]

thanks a lot for your help.

Answer 2

[BN]

Hello

Look at this line of your code:

simtickx(i) = sum( cell2mat(dat(p,2));   % one ) is missed

You don't close a parenthesis ), so :

simtickx(i) = sum( cell2mat(dat(p,2)));   % fixed

Further than this, I recommend you to use writetable instead of xlswrite.