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

Learning Hub
, ,
1

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

2

Hi @Syyed_Runanaz,

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

3

Hi,
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)

column types
column types1920×1080 375 KB
file types
file types1920×1080 538 KB
Labor report
Labor report1920×1080 290 KB

4

Hi @Syyed_Runanaz

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

5

yes all of them are integers