I need to count values from range as compare to other field

[GauravSS04]

I need to have field containing reportees which counts Line manager ID when compares to Employee.

Employee ID	Line Manager ID	Reportees	Reportees
86032967	86036821	=COUNTIF($B$2:$B$9,A2)	1
86036678	86036887	=COUNTIF($B$2:$B$9,A3)	3
86037883	86036678	=COUNTIF($B$2:$B$9,A4)	0
86000230	86036678	=COUNTIF($B$2:$B$9,A5)	0
86040205	86036678	=COUNTIF($B$2:$B$9,A6)	2
10001750	86032967	=COUNTIF($B$2:$B$9,A7)	0
86024971	86040205	=COUNTIF($B$2:$B$9,A8)	0
86000239	86040205	=COUNTIF($B$2:$B$9,A9)	0

[tresesco · Accepted solution]

Try like:

=SubStringCount(Concat(TOTAL [Line Manager ID], '-'),[Employee ID])

---

[GauravSS04]

It works just perfect...thanks for saving me from working on data model..