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:

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

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

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)