Hi All,

I need to create a countif statement based on two conditions, one of which is a sum of two possibilities. I.e. Column A: x, Column B: can be either Yes, Yes-R or No. I need to be able to count if column A = x and column B = Yes or Yes-R. So far I have: =Countifs(a:a, "x", b:b, "yes") though i am unsure how to create a group to categorize "yes" and "yes-r" as one pair. Do I use a sum statement somewhere in there? Any help is much appreciated. Let me know if you need further details. Thanks