hi everyone,


in test1 folder "Op List FEB-23 TEST 3.xlsx" is the main file. its data comes from the data folder files. test folder is in desktop location.


So here is the situation, i made the "Op List FEB-23 TEST 3" file to collect data from data folder according to date of files and sheet. "Op List FEB-23 TEST 3" sheet-01-02-23 data file 01-02-23-BB.xlsx, sheet-02-02-23 data file 02-02-23-BB.xlsx so far it works.


In cell#F7 it collected data from "01-02-23-BB" A1 M/C cell#O9. as you can see it has 2 different production data 195.5 & 100. so in cell#F7 i want sum this number since this two number is from same M/C. i tried didnt work since its in same column number. how do i sum it?


2nd in cell#F18 for M/C a12 there is 0 production. but in "01-02-23-BB" there is 244 kg production. why is it showing 0?


There the quite a few situations like this in this.

Attached Files

test1.zip (1.40 MB, 4 views)