How to use AVERAGEIF to include multiple rows of data

Hi everyone,

I have a block of data for which I would like to calculate an average. However, I only want rows of data to be used that meet a criteria. Please see the attached sample. I also copied it below for easy viewing. I want to calculate the average of the values in v1, v2, and v3, but only for those rows where Crit = c.

I want to do this for calculating averages, but would also like to know how to do this for other calculations. Not just averages. Thanks.

AvgSample.xlsx

C v1 v2 v3
a 4 4 7
b 6 1 1
b 2 6 5
a 5 7 6
c 1 1 2
b 7 1 4
a 5 5 3
b 2 6 6
c 6 7 1

Awesome!

The second one you suggested did it.

In the first one, the denominator returned a value of 2, I guess counting the number of times "c" showed up.

And the denominator in the second formula counts the number of times there is a value where Crit = c.

Now to go learn how all the functions you use work! Lol! Thank you very much for your help. I'll mark this post solved.