frequency in two dimensions?
 

I want to count frequency by two criteria, say segmenting population by
income AND size of household. Is there a quick way to do it?

Thanks!
XC

frequency in two dimensions?
 

Try this:

Column A = income
Column B = size of household

=SUMPRODUCT(--(A1:A100<50000),--(B1:B100=2))

Counts incomes <50K with household size of 2

Biff

"HuaXC" wrote in message
...
I want to count frequency by two criteria, say segmenting population by
income AND size of household. Is there a quick way to do it?

Thanks!
XC