Problem SUMIF-ing on an array

I do not have the time to generate an obfuscated sample - I will do so shortly. Admins - please keep the thread open. Thanks

Well, the solution to the problem was found. It's suboptimal but it works.
Basically, the column that holds that data regarding the existense of the specific quality was a formula. Once I changed the cells to values, the problem was solved. It's messy, and kinddog beats the point of having dynamically updated spreadsheet.

Can you better understand this issue now and perhaps advise why this happens?

Thanks