I don't want to type in all the SUMPRODUCT for all the different
permutation of criteria.

If you setup the criteria table properly you should only have to enter a
single formula and then drag copy.

Biff

"HuaXC" wrote in message
...
Thanks Dave! I don't want to type in all the SUMPRODUCT for all the
different
permutation of criteria.
Frequency function allows you to have excel look up in the bins and
automatically spits out statistics for each bin. Is there
a way to do that similarly on two dimensions?

XC

"Dave F" wrote:

Here's your post from yesterday, with a response:
http://groups.google.com/group/micro...2aded4 b5f271
--
Brevity is the soul of wit.


"HuaXC" wrote:

Sorry if this appears to be a repeat - I posted the same question
yesterday
afternoon but am not seeing it now, no matter how I search/browse for
it.
ANyway, I want to segment a bunch of data based on two criteria, let's
say
it's income and family size. Frequency function would give me the
distribution across segments on the income dimension or the family size
dimension. Is there a way to combine the two dimensions in one
calculation,
i.e. tell me how many data points fall into $50k-$60k income and family
size
of 2?

Appreciate your help!
XC