countif formula or sumif

[kumar1803]

Hello,

I need to count all " Yes" from " Converted Column" for each sales person below. Please help me build this formula from the following data:

[TABLE="width: 991"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SALES PERSON NAME[/TD]
[TD]DATE[/TD]
[TD]RESULTS[/TD]
[TD]LEAD SOURCE 1[/TD]
[TD]FINANCE QUALITY[/TD]
[TD]LEAD QUALITY[/TD]
[TD]AVERAGE SCORE[/TD]
[TD]CONVERTED[/TD]
[/TR]
[TR]
[TD]GARY K
[/TD]
[TD="align: right"]12/1/2015[/TD]
[TD]BAD PH #. NO RESPONSE[/TD]
[TD]CAR GURUS[/TD]
[TD]Finance Quality[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]CHRIS O
[/TD]
[TD="align: right"]12/1/2015[/TD]
[TD]NEVER SENT TRADE INFO[/TD]
[TD]WEBSITE OFFER[/TD]
[TD]Finance Quality[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]WADE B
[/TD]
[TD="align: right"]12/3/2015[/TD]
[TD]BAD CREDIT. NO ANSWER[/TD]
[TD] [/TD]
[TD]Finance Quality[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]CHRIS O
[/TD]
[TD="align: right"]12/3/2015[/TD]
[TD]NOT RESPONDING[/TD]
[TD]GOOGLE[/TD]
[TD]Finance Quality[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]GREG D
[/TD]
[TD="align: right"]12/3/2015[/TD]
[TD]NEEDS MORE CASH[/TD]
[TD]EBAY NATIONAL LISTING[/TD]
[TD]Finance Quality[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]CHRIS O
[/TD]
[TD="align: right"]12/3/2015[/TD]
[TD]SHOWED. DID NOT BUY[/TD]
[TD]EBAY NATIONAL LISTING[/TD]
[TD]Finance Quality[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]WAYNE S
[/TD]
[TD="align: right"]12/4/2015[/TD]
[TD]CANCELLED[/TD]
[TD]CARS.COM[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]GARY K
[/TD]
[TD="align: right"]12/4/2015[/TD]
[TD]NO SHOW. STILL SHOPPING[/TD]
[TD]GOOGLE[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]WADE B
[/TD]
[TD="align: right"]12/7/2015[/TD]
[TD]WORKING[/TD]
[TD]GOOGLE[/TD]
[TD]Finance Quality[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]CHRIS O
[/TD]
[TD="align: right"]12/5/2015[/TD]
[TD]STILL SHOPPING[/TD]
[TD]CARS.COM[/TD]
[TD]Finance Quality[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]GARY K
[/TD]
[TD="align: right"]12/7/2015[/TD]
[TD]SOLD[/TD]
[TD]CAR GURUS[/TD]
[TD]Finance Quality[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]GARY K
[/TD]
[TD="align: right"]12/5/2015[/TD]
[TD]SOLD[/TD]
[TD]CAR GURUS[/TD]
[TD]Finance Quality[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]YES[/TD]
[/TR]
</tbody>[/TABLE]


Thanks

 

[lrobbo314]

=Countifs([I]Converted column[/I],"Yes",[I]Name column[/I],[I]Agent name[/I])

 

[jim may]

Copy down Formulas

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L
1	SALES PERSON NAME	DATE	RESULTS	LEAD SOURCE 1	FINANCE QUALITY	LEAD QUALITY	AVERAGE SCORE	CONVERTED		SALES PER	YES	NO
2	GARY K	12/1/2015	BAD PH #. NO RESPONSE	CAR GURUS	Finance Quality	2	1	NO		CHRIS O	0	4
3	CHRIS O	12/1/2015	NEVER SENT TRADE INFO	WEBSITE OFFER	Finance Quality	3	1	NO		GARY K	2	2
4	WADE B	12/3/2015	BAD CREDIT. NO ANSWER		Finance Quality	1	1	NO		WADE B	1	1
5	CHRIS O	12/3/2015	NOT RESPONDING	GOOGLE	Finance Quality	1	2	NO		GREG D	0	1
6	GREG D	12/3/2015	NEEDS MORE CASH	EBAY NATIONAL LISTING	Finance Quality	3	1	NO		WAYNE S	0	1
7	CHRIS O	12/3/2015	SHOWED. DID NOT BUY	EBAY NATIONAL LISTING	Finance Quality	3	3	NO
8	WAYNE S	12/4/2015	CANCELLED	CARS.COM		3		NO
9	GARY K	12/4/2015	NO SHOW. STILL SHOPPING	GOOGLE		2		NO
10	WADE B	12/7/2015	WORKING	GOOGLE	Finance Quality	5	7	YES
11	CHRIS O	12/5/2015	STILL SHOPPING	CARS.COM	Finance Quality	3	3	NO
12	GARY K	12/7/2015	SOLD	CAR GURUS	Finance Quality	5	3	YES
13	GARY K	12/5/2015	SOLD	CAR GURUS	Finance Quality	4	6	YES
Sheet1

Cell Formulas
Range	Formula
K2	=COUNTIFS($A$2:$A$13,J2,$H$2:$H$13,K$1)
L2	=COUNTIFS($A$2:$A$13,J2,$H$2:$H$13,L$1)

 

[jim may]

Excel 2012
	J	K	L
1	SALES PER	YES	NO
2	CHRIS O	0	4
3	GARY K	2	2
4	WADE B	1	1
5	GREG D	0	1
6	WAYNE S	0	1
Sheet1

Cell Formulas
Range	Formula
K2	=COUNTIFS($A$2:$A$13,J2,$H$2:$H$13,K$1)
L2	=COUNTIFS($A$2:$A$13,J2,$H$2:$H$13,L$1)