Calculate average of data based on criteria in column A and minimum value threshold

[gmich13]

I am trying to simplify my task of calculating averages of data based on 2 differing criteria, one in column A is a label and column B actual value. I am at a loss on where to start with the formula, have tried using IF and AND/OR but I am stuck. See Sample Data below.

Column A Column B
9913 4.995
9913 5.789
9913 10.989
9913 27.899
9913 35.157
9914 2.078
9914 5.435
9914 10.745
9914 13.845

I would like to calculate the average of ALL 9913 data above a value of 5. I then would like to do the same for the 9914 data.

 

[inactiveuserps07]

Re: Need Help - Calculate average of data based on criteria in column A and minimum value threshold

@gmich13, if the "labels" in Column A are formatted as text, and the range (not including headers) were A2:B10:

=AVERAGEIFS($B$2:$B$10,$A$2:$A$10,"9913",$B$2:$B$10,">=5")

If your "labels" in Column A are actually real numbers, just omit the quotation marks around that part of the formula like this:

=AVERAGEIFS($B$2:$B$10,$A$2:$A$10,9913,$B$2:$B$10,">=5")

Change the label in the formula to 9914, etc., to get the average for amounts matching any label and >= 5.