Average with Certain Criteria in column

[trainer75]

Hi,

wonder if anyone can assist, I am trying to work out an average from multiple criteria that is in the same column.

I have criteria in column F and ratings from these in column H, but from the criteria I don't want to include certain elements.

I have made a range list of the elements and called it Elements

the formula I am using is
=averageifs(F:F,H:H,Elements)

from this, the formula is only picking up one of the elements

What I would like is IF column F has criteria in my list, then average the numbers in column H

Any help would be appreciated

 

[Scott T]

Try

=SUMPRODUCT(SUMIF(F:F,[COLOR=#333333]Elements[/COLOR],H:H))/SUMPRODUCT(COUNTIF(F:F,[COLOR=#333333]Elements[/COLOR]))