A | B | C | D | E | F | G | H | I | J | K | L | M |
Date | Route | Product 1 | Product 2 | Product 3 | MAY | |||||||
May 1 | 3 | 23 | 32 | 29 | Route | P1 | P2 | P3 | ||||
May 2 | 5 | 35 | 53 | 71 | 3 | |||||||
May 3 | 6 | 14 | 27 | 12 | 4 | |||||||
May 4 | 5 | 18 | 81 | 65 | 5 | |||||||
April 30 | 3 | 54 | 19 | 21 | 6 |
<tbody>
</tbody>
I want to total routes by the month. So see if I can explain this well enough.
I have a daily worksheet I fill out with date, route and products used on individual routes.
In another worksheet, I would like to keep a record of the amount of product used per month for each route.
I have been trying to use =Sumifs to compare the Month() in Column A to the Month() in J1 and while also comparing the Column B to the individual cell routes in Column J. Summing C,D,E into K,L,M respectively.
This doesn't match the table above, but...
{=sumifs('[Activity.xlsx]Night'!$J:$J,month('[Activity.xlsx]Night'!$B:$b),"="&month($B$1),'[Activity.xlsx]Night'!$c:$C,"="&$B4)}
This is my attempt...but Excel says that it isn't even a formula. Obviously doing something very wrong.
Thanks for your help!