I want to update count in the cell highlighted in red colour.
The condition is 2, The vertical column and horizon from Agent(I13) is my condition. but I am getting it wrong please help, I want add count based on both the condition.
>Solution :
Perhaps, its working on my end:
• Formula used in cell J14
=COUNTIFS($F:$F,$I14,$H:$H,K$13)
Fill Down & Fill Right !!