My goal is to find out the total number of each type of shift for the year.
I have each type of shift calculated out per month in their respective month columns:
I got the list of unique shifts for each month by using this formula for drawing the unique shifts from the month's sheet:
Then I got the total number of of the unique shifts for each month by using this formula where all the A cells had a 1 to count for the shift:
I then got the accumulated unique list from all the months by using this formula shown in the photo below:
Now my final task is to get a formula that will take all the respective numbers for all the unique shifts listed out by month and get the total numbers for each unique shift type for the yearly count. How do I do that? If you have the answer, please explain why as I am trying to understand the concept behind it. Thank you so much.