Excel unable to update count

Question

The cell with a red accent is the one I want to update the count in. The condition is 2, and my condition is the vertical column and horizon from Agent (I13). however if I'm doing it incorrectly, please advise. I want to add a count based on both conditions.

Answer 1

Try this:

---

• Formula used in cell J14

=COUNTIFS($F:$F,$I14,$H:$H,K$13)

---

Fill Down & Fill Right !!