Martinpetersson
New Member
- Joined
- Apr 27, 2022
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
Look up a value from a table on another sheet, based on its ID number and in a certain time frame. See attached minisheet.
I've made this testsheet, similar to the real one. Please help me to fill in formula in D25 & D29
Thank you for any help!
I've made this testsheet, similar to the real one. Please help me to fill in formula in D25 & D29
S-flow_hus60_utg4.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | ID | Good_parts | Time | Week | Year | Date | |||
2 | 121 | 30 | 2022-06-22 06:05 | 25 | 2022 | 2022-06-26 | |||
3 | 216 | 46 | 2022-06-22 07:56 | 25 | 2022 | 2022-06-26 | |||
4 | 864 | 24 | 2022-06-22 09:55 | 25 | 2022 | 2022-06-26 | |||
5 | 864 | 30 | 2022-06-22 11:35 | 25 | 2022 | 2022-06-26 | |||
6 | 121 | 22 | 2022-06-22 14:30 | 25 | 2022 | 2022-06-23 | |||
7 | 121 | 10 | 2022-06-23 08:30 | 25 | 2022 | 2022-06-23 | |||
8 | 121 | 5 | 2022-06-23 10:30 | 25 | 2022 | 2022-06-23 | |||
9 | 130 | 45 | 2022-06-23 12:51 | 25 | 2022 | 2022-06-23 | |||
10 | 216 | 44 | 2022-06-23 13:18 | 25 | 2022 | 2022-06-23 | |||
11 | 130 | 103 | 2022-06-23 13:39 | 25 | 2022 | 2022-06-23 | |||
12 | 120 | 75 | 2022-06-23 14:28 | 25 | 2022 | 2022-06-23 | |||
13 | 121 | 20 | 2022-06-23 14:30 | 25 | 2022 | 2022-06-23 | |||
14 | 121 | 10 | 2022-06-23 17:01 | 25 | 2022 | 2022-06-26 | |||
15 | 121 | 5 | 2022-06-23 18:30 | 25 | 2022 | 2022-06-23 | |||
16 | 864 | 24 | 2022-06-23 18:55 | 25 | 2022 | 2022-06-26 | |||
17 | 864 | 30 | 2022-06-23 18:55 | 25 | 2022 | 2022-06-26 | |||
18 | 216 | 46 | 2022-06-23 18:56 | 25 | 2022 | 2022-06-26 | |||
19 | 121 | 10 | 2022-06-23 19:01 | 25 | 2022 | 2022-06-26 | |||
20 | 121 | 30 | 2022-06-23 22:30 | 25 | 2022 | 2022-06-23 | |||
21 | |||||||||
22 | Sheet 2 below | ||||||||
23 | |||||||||
24 | Date to check up | Good parts with ID 121 between 06.00 -14.59 | |||||||
25 | 2022-06-23 | Should be 55 | |||||||
26 | Write any date ex. 2022-06-23 | Return sum of good parts in that timeframe | |||||||
27 | |||||||||
28 | Time and date now | Good parts with ID 121 between 06.00 -00:15 | |||||||
29 | 2022-06-27 14:51 | Should be 55 | |||||||
30 | Actual date now | Return sum of good parts in that timeframe | |||||||
test |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D25 | D25 | =+D29 |
B29 | B29 | =NOW() |
Thank you for any help!