I have agents initials in "Column D - AGT" and "Yes or No" in columns W/X.
Name Date Room AGT Yes No
Gaston 1/9 435 ERB Yes
Garcia 1/8 333 DW No

How do I calculate how many Yes votes and how many no for JUST AGT ERB???

Thanks!