Hi
i have the below sheet im working on.
on the summary tracker by month tab i need it to add the information from the FG warehouse tracker
in cell B10 on the summary tab i have all inputs for October (total pallets checked that month) this is from column L in the FG warehouse tab
in cell B11 i need the total input for columns M & N within the same period, i can get it to put one of these in but cant grasp how to get it to provide the totals for each month in the cell.
i want to try and avoid having an extra table just for the totals if possible
Thanks For any input
i have the below sheet im working on.
on the summary tracker by month tab i need it to add the information from the FG warehouse tracker
in cell B10 on the summary tab i have all inputs for October (total pallets checked that month) this is from column L in the FG warehouse tab
in cell B11 i need the total input for columns M & N within the same period, i can get it to put one of these in but cant grasp how to get it to provide the totals for each month in the cell.
i want to try and avoid having an extra table just for the totals if possible
Perpetual Tracker FG - RM 2022-2023 WIP.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | |||
2 | |||||||||||||||
3 | |||||||||||||||
4 | Warehouse 1 | ||||||||||||||
5 | Pallets Checked | ||||||||||||||
6 | Pallets Incorrect | ||||||||||||||
7 | Accuracy | ||||||||||||||
8 | |||||||||||||||
9 | warehouse 2 | ||||||||||||||
10 | Pallets Checked | 2742 | |||||||||||||
11 | Pallets Incorrect | 2 | |||||||||||||
12 | Accuracy | ||||||||||||||
13 | |||||||||||||||
14 | |||||||||||||||
15 | |||||||||||||||
16 | |||||||||||||||
17 | |||||||||||||||
18 | Over 98% is green | ||||||||||||||
19 | Below 98% is Red | ||||||||||||||
20 | |||||||||||||||
Summary Tracker by Month |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B10 | B10 | =SUMIF('FG Warehouse Perpetual Tracker'!K4:K39,"<=31/10/2022",'FG Warehouse Perpetual Tracker'!L4:L38) |
B11 | B11 | =SUMIF('FG Warehouse Perpetual Tracker'!K4:K39,"<=31/10/2022",'FG Warehouse Perpetual Tracker'!M4:M39) |
Perpetual Tracker FG - RM 2022-2023 WIP.xlsx | |||||||
---|---|---|---|---|---|---|---|
K | L | M | N | O | |||
3 | Date | Pallets Counted | Not issued | Not In stock | Wrong location | ||
4 | 04/10/22 | 2604 | 2 | 1 | 1 | ||
5 | 19/10/22 | 128 | 1 | 1 | |||
6 | 31/10/22 | 10 | 1 | ||||
7 | 01/11/22 | ||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 | |||||||
24 | |||||||
25 | |||||||
26 | |||||||
27 | |||||||
FG Warehouse Perpetual Tracker |
Thanks For any input