Your calc will return only the first "hit" in that long string of ELSEIFs.
If a hypothetical [Question Type] is "Archives ILL", your calc will only count the "Archives" part and will stop looking further. Typical computation logic for compound statements stops as soon as the first TRUE condition is hit. And that's what Tableau does.
Adding to Joe's comment as well, in computer logic "Archives" is not the same as "archives", so you would have to add a LOWER() around your CONTAINS() so that you're actually doing "archives" = "archives" but you might want to leave "ILL" as "ILL" depending on your data.
Chris!! Haven't seen you around lately! (Maybe we just haven't frequented the same threads...)
Merry Christmas to you, man! Some day I would like to experience a summertime Christmas! (But at least I do a little Aussie Christmas when I listen to my Christmas in Australia CD. "Six White Boomer", and other Aussie favorites. )