Forum Discussion
Solved
Need help with a COUNTIFS formula
I'm working on a spreadsheet for state reporting (I work for a school district) and I need to get the unduplicated number of students who received a suspension or in-house suspension. I've marked...
- Try this formula:
=SUM(COUNTIFS(A2:A57,”X”,
P2:P57,{“SUS”,”IH”}))
Hi dpeck,
this is a basic or function: =OR(B1="x",C1="x")
Which will return "true" if either or both cells are marked with an "x". otherwise, it returns false.
Alternatively you could use: =XOR(B1="x",C1="x")
Which returns true only if one or the other cells is marked with an "x" but if both or none are marked, then it returns false.
So adding this in your spreadsheet, in say column "Z", you could simply count the number of true or false.
Ben