Formula Help

Ty Werven

I am trying to set up a metric sheet that pulls from helper columns on a sheet. The helper columns are set up to count values in a multivalued drop down list. I am want to use the date (specifically the month) and then for each column in my metric sheet I want to use the value above in the column to count items per month. I will add screen shots.

So I have my date column I am trying to reference, and all my helper- columns that are returning a value that is in the 'What info is missing?" column

Here is my metric sheet that I am trying to set up.. for some reason when I get to the 2nd and 3rd columns it is giving me problems with 'cross referencing" I wonder if it has something to do with the $ in the formulas or just the formula in general?

The first column seems to work..

but the rest get all messes up as start as i try and do them.. like changing the refences in second column gives me this…

It is like all columns are connected somehow and I do not want them to be.