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
Quote:
|
={SUM(VLOOKUP(C7,'[01-02-23-BB.xlsx]DELEV-B'!$C$8:$O$771,{13},0))}
|
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.
Quote:
|
I cannot change anything in data files. they are raw data.
|