All
I'm looking for a SUMPRODUCT formula (if feasibly) similar to the ones cells G, H, I 21, on these cells the formulas work fine when the formulas look at (opened) individual file by hour (7.csv,8.csv,etc).
On cells C, D,E 21 would like to get the same result, however looking to "Time from & Time to". The aim is that, run a daily (24h) report rather than run it by each hour, preferably without to have to open the source (.csv) files.
Each daily report will be named as: Batch_Yield_Report2017_04_27.csv
source files csv renamed to txt
dest file= .xlsm
Thanks in advance.
Regards
R
I'm looking for a SUMPRODUCT formula (if feasibly) similar to the ones cells G, H, I 21, on these cells the formulas work fine when the formulas look at (opened) individual file by hour (7.csv,8.csv,etc).
On cells C, D,E 21 would like to get the same result, however looking to "Time from & Time to". The aim is that, run a daily (24h) report rather than run it by each hour, preferably without to have to open the source (.csv) files.
Each daily report will be named as: Batch_Yield_Report2017_04_27.csv
source files csv renamed to txt
dest file= .xlsm
Thanks in advance.
Regards
R