Use a Pivot table.

HTH,
Bernie
MS Excel MVP


"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