Average Formula using multiple columns

Occasional Visitor

I am trying to do an average formula using an “If(And” function and I am having difficulty getting it to work.

 

Mgundel_0-1650995342970.png

 

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)

 

 

 

 

 

1 Reply

@Mgundel 

=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.