No images as of now…If anyone having idea I’ll share excel sheets
How to sum (entire column) different columns having different names... present in different excel file but in sheet 1
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)
Dose “Reg hrs”, “Billable hours” have numeric values for sum ?
yes all of them are integers