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?