Forum Discussion

Marcus_Booth's avatar
Marcus_Booth
Iron Contributor
May 19, 2025

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

Hello everyone! Thank you in advance for any assistance you are able to offer.  I'm working in MS 365 for web on a windows cloud environment through a Citrix network. Looking for a formula that wil...
excel
Excel for web
Formulas and Functions
Kidd_Ip's avatar
Kidd_Ip
MVP
May 20, 2025

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

 

Resources