enter image description hereThank you so much for your support,
I would like to know this suggestion can work.
I have 2 sheets. the first one called ‘Employee’ the second ‘Database’
in ‘Employee’ sheet in cell ‘AO3’ I want to bring the sum of comment ‘ Meet Expectation’ how much declared for ‘x’ employee based on ‘Database’ sheet.
but since there are many employees , I want this code bring only the information related to ‘x’ employee matching cell ‘S3’ which is let say ‘Roberto’ and match also comment ‘Meet expectation’ then this code will go to ‘Database’ sheet and look matching for ‘Roberto’ and count how mush ‘Meet expectation’ was declared, and give just a value ‘3 times or 1 time or 0 ‘

I hope that I explain in a good way,

I tried this Code , but not working at all

=IFERROR(INDEX(COUNTIF(‘Database’!$E$2:$E$1000,AN3),MATCH(E3,’Database’!$B$2:$B$1000,0), MATCH(AO3,’Database’!$E$2:$E$1000,0),””)