In column B, if the word “OTHER” appears in the cell, I want it to count the “x” in column E and display the result in C6. I can not determine what function will give me accurate results for what I need. Do I need to nest a function, or can I use just COUNTIF? Thank you!!!