How to use averageif function?

2
votes

I have a following data set. I want to get, in column E, average of column B values , if the sample and gene are same using something like AVERAGEIF function in Excel.

For example, in E2 cell, I want to have the the average of B2 and B7 since they have same value in column C i.e "alpha", and column D i.e "S14".

Here is the screenshot of sample data:

enter image description here

1
excelexcel-formulaexcel-2010
You would need AVERAGEIFS(): support.office.com/en-us/article/… - Scott Craner
ya, I think I need that, but I am not sure about the formula for such cases - alpha189
The link I provided give a good tutorial on how to use it. It will be much more detailed than anything we can give. - Scott Craner
I have checked it, but I am not sure how can I define "criteria" saying that values in column(x) are equal/same. - alpha189

1 Answers

3
votes

You would need AVERAGEIFS()

The Formula would be:

=AVERAGEIFS(B:B,C:C,C2,D:D,D2)

Put it in E2 and copy/drag down.