Complex Formulas
 

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!

Complex Formulas
 

=sumproduct(--(d$1:d$1000="ERB"),--(w$1:w$1000="Yes")) will count each Yes
associated with ERB. Change the conditions / columns as needed.

"TiaB" wrote:

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!

Complex Formulas
 

Thank YOU!!!!! That works wonderfully!

:)

"bpeltzer" wrote:

=sumproduct(--(d$1:d$1000="ERB"),--(w$1:w$1000="Yes")) will count each Yes
associated with ERB. Change the conditions / columns as needed.

"TiaB" wrote:

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!