IRStuff, the problem is that that particular function (Countifs) does not even exist in older versions of excel. So even if you have the compatibility pack, or if you save "down" the original file, that function won't work if you're not using excel 2007. There are a couple of other functions...
Try this instead. I did a quick google search and found a solution here: http://spreadsheetpage.com/index.php/tip/summing_and_counting_using_multiple_criteria/
Basically intead of using COUNTIFS it makes use of multiplying two booleans together. So, if both columns aren't what you want, the...
I hope this isn't too late..
Assuming that you want to do this all within the worksheet, and not use VBA or anything like that, perhaps, on a second sheet in the workbook, you can create it so that it lists the case number followed by whether or not the contributing factor applies to that case...
