Very urgent


#1

Hello,

I’m looping through à folder:
1-it contain many other folders:
A
B
C
D

each one contain an excel files named as following: À+date, B+ date

I need to sum columnAD for each excel file
I had an other excel file which is à référence:
Its format is

À. 11. 44. 55 66 77
À. 22 44 66 66 99
B 11 33 44 55 66
B 22 66 77 88

I need to sum the 4thcolumn for A and B and make the différence between this sum and the one listes above


#2

@abdel If u provide files in zip it will be helpful


#3

Hello!

What kind of problem are you facing off? Also, it will help us if you share your workflow :slight_smile:

Regards,


#4

making the sum of:

FT550 -732,70
FT550 -51,30
FT550 -23 040,00
FT550 131 333,86
FT550 -107 510,00
FT550 3900 0,14
FR7K0 -2 514,67
FR7K0 2 514,67