I'm currently extracting data from a larger table to a smaller summary table
(on a different tab) using the SUMPRODUCT function in this form (an example):

=SUMPRODUCT(--(CNTXTName="Shared
Hosting"),--(CNTXTProd=$C253),--(CNTXTMonthRange=E$15),--(CNTXTYearRange=E$14),CNTXTOrders)

to add the values of CNTXTOrders in the rows that meet the preceeding given
conditions in the formula.

QUESTION: I need to find a way to do the same operation but AVERAGE the
values (instead of summing them) and COUNT the occurence of values that are
equal to or less than 10.

Can anyone advise on a way to do this??? Unfortunately this is part of an
elaborate spreadsheet, so I'm structurally limited (can't rearrange the
data).

Any advice would be so much appreciated as I'm already past my deadline.

Many, many thanks,

Marika :) :)