Formula to Filter 1 or more columns based on criteria and then perform basic math on another column (based on the filter)

[queysoft]

HI there - So, I don't have O365 subscription (yet) - trying to get work to buy it for us.

Column A = List of words (example Apple.....Pear.....Orange)
Column B = List of words (example Apple.....Pear.....Orange)
Column C = A number (example 123, 432, 734......n)

In a cell, I would like to automate (or at least enter a formula) to Filter column A on a certain word (Apple) and then either AVERAGE / MAX / MIN the filtered values for the word Apple.
Then I would like another formula to do the same using values in column A and B.

It would be nice to make this into a button to click to display the information- Is that possible without using VBA?

Thank you.

 

[queysoft]

Sorry - can't install XL2BB at work - hope the screen shot works.......Sheet 1 is called "test". Maybe its me and the way i am entering the array formula - I just close the last bracket and press CSE?

 

[Fluff]

You're ranges are all different sizes, they should be the same.

 

[queysoft]

Cool - I Understand and can work this in now. Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.