Average :

=AVERAGE(IF(--(CNTXTName="Shared
Hosting")*--(CNTXTProd=$C253)*--(CNTXTMonthRange=E415)*--(CNTXTYearRange=E$1),CNTXTOrders))



"Vasant Nanavati" wrote:

(Untested):

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

should give you the average.

=SUMPRODUCT(--(CNTXTName="Shared
Hosting"),--(CNTXTProd=$C253),--(CNTXTMonthRange=E$15),--(CNTXTYearRange=E$1
4),--(CNTXTOrders<=10))

should give you the number of occurrences less than or equal to 10.

--

Vasant




"marika1981" wrote in message
...
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$1
4),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 :) :)