LearningByDoing
New Member
- Joined
- Aug 17, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello together,
I have the following problem.
I want the total weight of the tonnage per shift (Column shift - 1 or 2) and by date. The total weight should be added in each row of the 1st trip.
As can be seen in the column "My incomplete result", I have succeeded for the 1st shift. The formula I used for the calculation: =IF($D4=1;SUM(IF($A4:$A57=$A4;IF($C4:$C57=1;$E4:$E57); "#N/A")); "#N/A")
With the calculation and representation of the 2nd shift I have my difficulties. Complementary difficulty is that I want to have the calculation and representation in one column.
It would be great if not only a solution was presented, but also why this solution was chosen. I would like to understand how the approach to the solution was made.
Would you like more information? I will be happy to provide it.
Thank you in advance.
Janus
I have the following problem.
I want the total weight of the tonnage per shift (Column shift - 1 or 2) and by date. The total weight should be added in each row of the 1st trip.
As can be seen in the column "My incomplete result", I have succeeded for the 1st shift. The formula I used for the calculation: =IF($D4=1;SUM(IF($A4:$A57=$A4;IF($C4:$C57=1;$E4:$E57); "#N/A")); "#N/A")
With the calculation and representation of the 2nd shift I have my difficulties. Complementary difficulty is that I want to have the calculation and representation in one column.
It would be great if not only a solution was presented, but also why this solution was chosen. I would like to understand how the approach to the solution was made.
Would you like more information? I will be happy to provide it.
Thank you in advance.
Janus
| Desired Result | Formel: =IF($D4=1;SUM(IF($A4:$A57=$A4;IF($C4:$C57=1;$E4:$E57);"#N/A"));"#N/A") | ||||||
| date | code | shift | trip | weight [kg] | Total Weight per shift and date | My incomplete result so far | |
02.01.2023 | 1 | 1 | 1 | 23760 | 93420 | 93420 | |
02.01.2023 | 1 | 1 | 2 | 23840 | #N/A | ||
02.01.2023 | 1 | 1 | 3 | 23500 | #N/A | ||
02.01.2023 | 1 | 1 | 4 | 22320 | #N/A | ||
02.01.2023 | 1 | 2 | 1 | 22960 | 89100 | 0 | |
02.01.2023 | 1 | 2 | 2 | 22320 | #N/A | ||
02.01.2023 | 1 | 2 | 3 | 22560 | #N/A | ||
02.01.2023 | 1 | 2 | 4 | 21260 | #N/A | ||
03.01.2023 | 1 | 1 | 1 | 24440 | 99340 | 99340 | |
03.01.2023 | 1 | 1 | 2 | 24060 | #N/A | ||
03.01.2023 | 1 | 1 | 3 | 25740 | #N/A | ||
03.01.2023 | 1 | 1 | 4 | 25100 | #N/A | ||
03.01.2023 | 1 | 2 | 1 | 24780 | 171760 | 0 | |
03.01.2023 | 1 | 2 | 2 | 23280 | #N/A | ||
03.01.2023 | 1 | 2 | 3 | 23920 | #N/A | ||
03.01.2023 | 1 | 2 | 4 | 23880 | #N/A | ||
03.01.2023 | 1 | 2 | 5 | 25220 | #N/A | ||
03.01.2023 | 1 | 2 | 6 | 25880 | #N/A | ||
03.01.2023 | 1 | 2 | 7 | 24800 | #N/A | ||
04.01.2023 | 1 | 1 | 1 | 23160 | 233580 | 233580 | |
04.01.2023 | 1 | 1 | 2 | 25120 | #N/A | ||
04.01.2023 | 1 | 1 | 3 | 27580 | #N/A | ||
04.01.2023 | 1 | 1 | 4 | 23300 | #N/A | ||
04.01.2023 | 1 | 1 | 5 | 23000 | #N/A | ||
04.01.2023 | 1 | 1 | 6 | 22120 | #N/A | ||
04.01.2023 | 1 | 1 | 7 | 22800 | #N/A | ||
04.01.2023 | 1 | 1 | 8 | 23680 | #N/A | ||
04.01.2023 | 1 | 1 | 9 | 22000 | #N/A | ||
04.01.2023 | 1 | 1 | 10 | 20820 | #N/A | ||
04.01.2023 | 1 | 2 | 1 | 22300 | 187740 | 0 | |
04.01.2023 | 1 | 2 | 2 | 22300 | #N/A | ||
04.01.2023 | 1 | 2 | 3 | 23180 | #N/A | ||
04.01.2023 | 1 | 2 | 4 | 24300 | #N/A | ||
04.01.2023 | 1 | 2 | 5 | 23860 | #N/A | ||
04.01.2023 | 1 | 2 | 6 | 23700 | #N/A | ||
04.01.2023 | 1 | 2 | 7 | 23700 | #N/A | ||
04.01.2023 | 1 | 2 | 8 | 24400 | #N/A | ||
05.01.2023 | 1 | 1 | 1 | 22600 | 95460 | 95460 | |
05.01.2023 | 1 | 1 | 2 | 24420 | #N/A | ||
05.01.2023 | 1 | 1 | 3 | 25640 | #N/A | ||
05.01.2023 | 1 | 1 | 4 | 22800 | #N/A | ||
05.01.2023 | 1 | 2 | 1 | 22780 | 160960 | 0 | |
05.01.2023 | 1 | 2 | 2 | 23340 | #N/A | ||
05.01.2023 | 1 | 2 | 3 | 23640 | #N/A | ||
05.01.2023 | 1 | 2 | 4 | 23920 | #N/A | ||
05.01.2023 | 1 | 2 | 5 | 24780 | #N/A | ||
05.01.2023 | 1 | 2 | 6 | 21380 | #N/A | ||
05.01.2023 | 1 | 2 | 7 | 21120 | #N/A | ||
09.01.2023 | 1 | 1 | 1 | 23340 | 117900 | 117900 | |
09.01.2023 | 1 | 1 | 2 | 23700 | #N/A | ||
09.01.2023 | 1 | 1 | 3 | 23600 | #N/A | ||
09.01.2023 | 1 | 1 | 4 | 23040 | #N/A | ||
09.01.2023 | 1 | 1 | 5 | 24220 | #N/A | ||
09.01.2023 | 1 | 2 | 1 | 24040 | 24040 | 0 | |
| SUM | 1273300 |
