Many thanks, I'm only a few days with this program and find the syntax unlike anything I've used in the past, but its progress.
I can easily import the XLSX file
data= Import["c:\Users\lvveen\Downloads\ssc.xlsx", {"Data", "Sheet1", 1 ;; 72, 1 ;; 30}]; % // Dimensions
Gives {72, 30}
data[[All, 2]] // Total
gives -66552.4
I've added the files I'm working with. The excel file contains data for overhead cables, one cable per row.G
I import excel files (xlsx) and csv files frequently and encounter no problem. Would you mind attach your file and your code for import? so I can have a check.
