Excel Formula Combine MATCH , INDEX, COUNT

Question

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 many 'Meet expectation' were declared, and give just a value '3 times or 1 time or 0 '

I tried this Code , but not working at all

=IFERROR(INDEX(COUNTIF('Database'!$E$2:$E$1000,AO3),MATCH(E3,'Database'!$B$2:$B$1000,0), MATCH(AO3,'Database'!$E$2:$E$1000,0),"")

Foxfire And Burns And Burns · Accepted Answer · 2024-05-10 08:40:24Z

2

You can try this formula:

=IFERROR(COUNTIFS(Database!$E:$E;Employee!AO$2;Database!$B:$B;Employee!$E$2);"")

edited May 10, 2024 at 8:40

Foxfire And Burns And Burns

12.1k2 gold badges19 silver badges43 bronze badges

answered May 10, 2024 at 8:28

Kate Nichols

362 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Formula Combine MATCH , INDEX, COUNT

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related