Help with complex query

Hi, Thanks in advance. I'm trying to creat a new Incidents column in a table based on some complex conditions. I have 48 vars that calculate the count of department names occur in an affected Dept...