COUNTIFS monthly project tracking.

I want to track project progress as Open / Complete across months. I have my work log in Sheet 1, and metrics calculations in Sheet 2.
Sheet 1 has the following Named Ranges that I care about: YearReceived, MonthReceived, MonthComplete.
I want my formula in Sheet 2 to tally projects that are open at the end of each month, or active if in the current month. Column B is January, C is February and so on.

Conceptually my formula would COUNTIFS my open jobs:
YearReceived is current year
MonthComplete occurs after MonthReceived
& MonthReceived is before each month

=COUNTIFS(YearRecvd,2018,MonthComplete,">"&MonthRecvd,MonthRecvd,"<"&COLUMN())

I don't think my criteria set 2 and criteria set 3 sections are working as I want. I may not be have the correct logical comparison in criteria set 3. It's got my mind tied in a knot at the moment.
Anybody know how to get through this?

How about I attach the file, that may help right? I've removed a few things that wouldn't be relevant to my problem, sanitizing my data a little.

In metrics I'm working on my formula for row 4, I think I can work out the previous years in row 3. Ultimately I will be adding these values together for my running tally of open work.