How to calculate KPI's in excel

[IAkuma]

Hello All,

Could someone please help me with the issue described in the pic below. Thanks!

 

[AliGW]

In D13 copied down:

=COUNTIF($D$4:$M$9,C13)

 

[IAkuma]

Morning AliGW,

Thanks for the reply.

The total amount per employee is already calculated in the left table with the following formula (=COUNTIF(D4:N9,"JD") must admit the one you suggested is much more precise. The struggle is now to make calculation per employee for registered document in each month and year. This report suppose to show each employee's contribution.

I hope this clarify the issue better.
IAkuma