Need help finding a function, please

[plo888]

I'm looking for a function that will calculate results from data filtering.

Within my spreadsheet, I have a list of companies (Column A) followed by their sector code (column B), the eps result (either beat, miss, or meet) (column C) and then a return amount (Column D).

Which excel function would you suggest I use If I want filter for:

information technology (IT) sector AND

beat their eps

THEN only return back the average of the returns of all those IT companies?

At first glance, I'm think sumproduct with average function, but not certain.

Thanks in advance

 

[T. Valko]

Biff, I will never doubt you.
Strangely, I tried it with the rest of the sectors and they match my manual labor filtering.

I will adjust accordingly and greatly appreciate your follow up.

You're welcome. Thanks for the feedback!