Forum Discussion
Average Formula using multiple columns
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 transact...
=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.