So heres the situation. Im gonna be adding up a range of cells if they meet a certain criteria. The cell can either be a yes, or a no. I have the formula setup so that it counts the cells that say yes, and the cells that say no using COUNTIF's nested within IF's. But i also need to do a total of both yes and no's. How do i do that for the criteria of COUNTIF. i have tried doing COUNTIF(cell range, OR("Yes","No")), but that just returns true, and then wants to add if they are TRUE, but the cells only say yes and no, so i get a 0. Is there a way to check for both yes and no with only 1 criteria?