Calculate employee monthly performance

[Georgiy]

Good morning,

How to calculate the monthly performace by employee? I am using a long and I think a wrong way to do it, please see attached, using concatenate and countif functions in order to get the result in a table, is there any other function?

Thank you and have a good day,

[benishiryo]

hi Georgiy, welcome to the forum. you can try:
=SUMPRODUCT((TEXT(SHEET1!$B$2:$B$5454,"mmyy")=TEXT(C$11,"mmyy"))*(SHEET1!$C$2:$C$5454=$B12))

or in Excel 2007 & above:
=COUNTIFS(SHEET1!$B$2:$B$5454,">="&C$11,SHEET1!$B$2:$B$5454,"<="&EOMONTH(C$11,0),SHEET1!$C$2:$C$5454,$B12)

[Georgiy]

hi Georgiy, welcome to the forum. you can try:
=SUMPRODUCT((TEXT(SHEET1!$B$2:$B$5454,"mmyy")=TEXT(C$11,"mmyy"))*(SHEET1!$C$2:$C$5454=$B12))

or in Excel 2007 & above:
=COUNTIFS(SHEET1!$B$2:$B$5454,">="&C$11,SHEET1!$B$2:$B$5454,"<="&EOMONTH(C$11,0),SHEET1!$C$2:$C$5454,$B12)

Thank you very much, you amazing! you was faster then my post , 100% what I am looking for, appreciate.

Administration, please advise how can I mark this thread as solved?

Have a good day,