deletedalien
Well-known Member
- Joined
- Dec 8, 2008
- Messages
- 505
- Office Version
- 2013
- Platform
- Windows
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
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