Hi, I went through the trouble of de-constructing my major workbook to a test workbook because I know I can't figure this out on my own.

I need to cross reference several variables, and count if a number is shown, in a particular month, based on a drop-down, an indicator box and other variables.

It's extremely difficult to explain without a dummy, so please if you're up for a challenge, take a look.

Thanks

test.xlsx