Complex Formulas

T

TiaB

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!
 
B

bpeltzer

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

TiaB

Thank YOU!!!!! That works wonderfully!

:)

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