Apr 26 2022 10:51 AM
I am trying to do an average formula using an “If(And” function and I am having difficulty getting it to work.
The spreadsheet is tracking information based on the reviewer of a transaction (Connie Daniels or Jack Whitt). If the “Error Code” field is “None” this means the review was correct with no errors. Any other response means the review was incorrect. I am trying to calculate the average for each reviewer.
If it was a math equation it would be……
(The number of Connie Daniels reviewed calls that scored “None”)
Over
(The number of Connie Daniels reviewed calls)
Apr 26 2022 11:07 AM
=SUMIFS(score_range, reviewer_range, "Connie Daniels", errorcode_range, "None")/SUMIFS(score_range, reviewer_range, "Connie Daniels")
You can, of course, replace "Connie Daniels" with a reference to a cell that contains the reviewer's name.