Don, many thanks....unfortunately, from the equations you offered, I'm still
unable to figure out how to apply the formula to just those rows that meet
three or more conditions (as I showed in the SUMPRODUCT formula below). It's
akin to a triple vlookup, though no qualifiying data falls in the left
column. Once I've targeted those rows, then I need to perform AVERAGE,
COUNTIF, etc on a certain column...

Let me know if you have any ideas and forgive me if I misunderstood your
reponse.

Marika

"Don Guillett" wrote:

try these ideas. You should be able to figure it out from there
maybe this ARRAY formula to be entered with control+shift+enter instead of
just enter

=COUNT(IF(($B$1:$B$5=B1)*($A$1:$A$5),1))
=COUNT(IF(A2:A4,1,B2:B4))
=AVERAGE(IF(rngSMALL(rng,4),IF(rng<LARGE(rng,4),r ng)))
=AVERAGE(IF((A1:A4="jones")*(C1:C40),C1:C4))
=AVERAGE(IF(K7:K220,K7:K22))
=AVERAGE(IF($H$3:$H$23=C11,$K$3:$K$23)


--
Don Guillett
SalesAid Software

"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 :) :)