count sales per Salesman

[deletedalien]

so.....

this seems to be pretty straightforward but for the life of me i can't seem to think of a formula that could work with this....


i have a list of salesmen who well.... made sales...

and i need to count the amount of sales per salesman, however, the salesman nema only shows up once per sales report...

See file here:
https://1drv.ms/x/s!Agyr_mEIeS75gaZsHzHC_kd_G-5sGg?e=dEze1a

how can i count the total lines per salesman,

say

salesman 12355, who sold 115,464.78, he has a total of 5 sales (5 lines under him...)

Salesman 12587 who sold 197,053.27 He has a total of 7 sales (has 7 lines under him...)


this is a short report but some of these include up to 30 salesmen.

is this even possible?

Thanx in advance

 

[kweaver]

Make these changes:

Excel 2010
	D	E	F
53	Pancho Villa	115,464.78	5
54	Emiliano Zapata	197,053.27	7
55	Enrique Pena Nieto	150,000.00	3
SalesPeople

Cell Formulas
Range	Formula
E53	=SUMIF($H$1:$H$1000,D53,$I$1:$I$1000)
F53	=COUNTIF($H$1:$H$1000,D53)
D53	{=INDIRECT("H"&SMALL(IF(ISNUMBER(SEARCH("Name",$H$1:$H$1000)),ROW($H$1:$H$1000),""),(ROW()-52))+1)}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[deletedalien]

LOL!!!!

The NAMES dude!!!

ok ok ok let me try this.

 

[kweaver]

I didn't want to use "Random Name" since I'm your neighbor!

 

[deletedalien]

YES!!!!!!!!!!!!!!

THAT totaly worked!!!!!

AWESOME!

Thanx a whole MUCHO!!!!

 

[kweaver]

Great News! Have a great afternoon.

 

[deletedalien]

Thanx u do as well.