Re: Formula needed to retrieve % of correct reviews for an employee, where reviews are on separate tabs.

Suppose you can consider the following:

 

1. Retrieve the total number of reviews conducted within the selected date range.
2. Count the number of failed reviews.
3. Compute the percentage of correct reviews with this formula:

Correct % = (Total Reviews - Failed Reviews) / Total Reviews * 100

 

Given that your data is spread across multiple worksheets, you can use SUMIFS or COUNTIFS functions to gather relevant information for an employee within the specified date range:

= (SUMIFS('Sheet1:SheetN'!B:B, 'Sheet1:SheetN'!A:A, Results!A2, 'Sheet1:SheetN'!C:C, "Pass", 'Sheet1:SheetN'!D:D, ">=" & StartDate, 'Sheet1:SheetN'!D:D, "<=" & EndDate))
/
(SUMIFS('Sheet1:SheetN'!B:B, 'Sheet1:SheetN'!A:A, Results!A2, 'Sheet1:SheetN'!D:D, ">=" & StartDate, 'Sheet1:SheetN'!D:D, "<=" & EndDate))
* 100