What I need to find:
-ID 1 or ID 2 is from rp
-Particular week (eg.week 80)
-Count only if the status is successful
How the worksheet looks like:
Sheet 2(details of the people and the division they are in):
How my code looks like:
The above code does not work. Any help will be appreciated. Thank you!