Hello folk.
I'm trying to create a work schedule in which the worker only advances if it's their turn. So I have a worksheet for the actual schedule and another one to add the money said worker makes in a year, let's assume.
What I would want is to create a formula that adds automatically all the money values and disregards the date.
Regarding the excel sheets:
1. This one sums all the money and gives back the dates when he worked. The codes are in the upper left corner. So if he worked with the D1 code, he would have made 52,78 €.
D is for day shift and N is for night shift. The 1 and 2 next to each letter represents overtime.
The formula in total (€) is pretty outdated since it sums all the cells individually, like so: =SUM(C10;E10;G10;I10;K10;M10;O10;Q10;S10;U10;W10;Y10;AA10;C19;E19;G19;I19;K19;M19;O19;Q19;S19;U19;W19;Y19;AA19;C28;E28;G28;I28;K28;M28;O28;Q28;S28;U28;W28;Y28;AA28)
Is there a way to make a formula that I can drag where if a cell contains money, it adds that cell, otherwise it ignores it, since if I drag it to the end it'll add all the dates as well?
Also for the formula in values code 1, I used VLOOKUP: =VLOOKUP(CODE1!C16;CODE1!$A$1:$B$7;2;FALSE), however I add to paste it in every other cell, also individually, because I want the cell next to the code to give back the date and not an error.
The formula in the dates is the following: =IF(CODE1!C16="";"";CODE1!C16), so its also pasted individually in each date cell.
2. This is the work schedule in which worker 3 is behind and should be the next one to advance.
I know it sounds confusing so if you have any questions please do ask them. This'll help a lot my work load.
Thanks in advance.
I'm trying to create a work schedule in which the worker only advances if it's their turn. So I have a worksheet for the actual schedule and another one to add the money said worker makes in a year, let's assume.
What I would want is to create a formula that adds automatically all the money values and disregards the date.
Regarding the excel sheets:
1. This one sums all the money and gives back the dates when he worked. The codes are in the upper left corner. So if he worked with the D1 code, he would have made 52,78 €.
D is for day shift and N is for night shift. The 1 and 2 next to each letter represents overtime.
The formula in total (€) is pretty outdated since it sums all the cells individually, like so: =SUM(C10;E10;G10;I10;K10;M10;O10;Q10;S10;U10;W10;Y10;AA10;C19;E19;G19;I19;K19;M19;O19;Q19;S19;U19;W19;Y19;AA19;C28;E28;G28;I28;K28;M28;O28;Q28;S28;U28;W28;Y28;AA28)
Is there a way to make a formula that I can drag where if a cell contains money, it adds that cell, otherwise it ignores it, since if I drag it to the end it'll add all the dates as well?
Also for the formula in values code 1, I used VLOOKUP: =VLOOKUP(CODE1!C16;CODE1!$A$1:$B$7;2;FALSE), however I add to paste it in every other cell, also individually, because I want the cell next to the code to give back the date and not an error.
The formula in the dates is the following: =IF(CODE1!C16="";"";CODE1!C16), so its also pasted individually in each date cell.
2. This is the work schedule in which worker 3 is behind and should be the next one to advance.
I know it sounds confusing so if you have any questions please do ask them. This'll help a lot my work load.
Thanks in advance.
