CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
alpha189
alpha189

Reputation: 93

How to use averageif function?

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

Upvotes: 2

Views: 1098

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

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.

Upvotes: 3

Related Questions