Counting locations per name

[Spreadsheetz]

Hello!

Hopefully this is an easy one.. I have a spreadsheet with a number of names in one column, and locations in another column. I'm hoping to find a formula that can tell me how many times the location shows up per person.

For example:

location	name
Calfornia	Jeff
Maine	Mary
California	Jeff
Michigan	Mary
Michigan	Mary
Wyoming	Jeff

<tbody>
</tbody>

Is there a function to use that could quickly spit out something like this:

location	name	count
california	jeff	2 california, 1 wyoming
maine	mary	2 michigan, 1 maine
california	jeff	2 california, 1 wyoming
Michigan	Mary	2 michigan, 1 maine
Michigan	mary	2 michigan, 1 maine
Wyoming	Jeff	2 california, 1 wyoming

<tbody>
</tbody>

Just a count of how many times the value in the location column occurs per name.

Thanks in advance!!

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​	location	name		name	location	California	Michigan	Wyoming	Maine
2​	California	Jeff		Jeff		2​	0​	1​	0​
3​	Maine	Mary		Mary		0​	1​	0​	2​
4​	California	Jeff
5​	Maine	Mary
6​	Michigan	Mary
7​	Wyoming	Jeff

<tbody>
</tbody>

f2=COUNTIFS($B$2:$B$7,$D2,$A$2:$A$7,F$1) copy across and down