How to sum (entire column) different columns having different names... present in different excel file but in sheet 1

No images as of now…If anyone having idea I’ll share excel sheets

Hi @Syyed_Runanaz,

Can you explain properly ur require…if with excel possible?

1.There is a column name sample source file(Cell B). I’ve to read those files either its a csv or xlsx.Is there any format/activity that reads both formats of files because I cant change Format of the file.
2. Next step is I’ve to sum all the columns (Cell J-K) in green color for each client i.e Per row.
3. I’ve to subtract them with Hours worked(Cell Q)

Hi @Syyed_Runanaz

Dose “Reg hrs”, “Billable hours” have numeric values for sum ?

yes all of them are integers