See attached.
To make things easier, I applied the first of the month dates as headers. You can format these to show just the month as you had. I am assuming you are going from 2011 to 2012.. change as necessary.
Then you can use this formula in B12:
Note that it references cells for criteria instead of hard-coding the criteria. This is better as you can copy down and across the column without manipulating the formula in each cell.
Also note that you need to watch for extra spaces... your Brandie entries had extra ending space.. which I removed and I changed Supportive Services in A11 to singular Supportive Service to match column M on the other sheet.
When you put the formula in the other tables, you will need to adjust the criteria cells... ensure the $ signs remain where they are.
Bookmarks