Formula Question

Sean J.

I have a form where new paramedics are rated based on their performance on a call. There are multiple topics for each call. The evaluators rate the medic using a form. All of the medics are on a single sheet. Each row has a column that averages the scores. I am trying to create a formula that collects all of the average scores and places them in a single cell. I want to filter it by medic. Is this possible?

Darren Mullen

@Sean J. Yes, you can use AVERAGEIF() function if you only have 1 criterion. Otherwise you'd just use SUMIFS() to sum up each medic's scores then divide that by the number of scores received by medic which can be calculated using COUNTIFS()

Darren Mullen

@Sean J. Yes, you can use AVERAGEIF() function if you only have 1 criterion. Otherwise you'd just use SUMIFS() to sum up each medic's scores then divide that by the number of scores received by medic which can be calculated using COUNTIFS()