I think I'm close to finally figuring out my issue and I think I need to use an array formula. The trouble is, I'm not too great at array formulas. Here's a simplified version of what I'm working on.
I have a sheet that has a list of programs down column A. Across row 1 I have the check...