frequency in two dimensions?

H

HuaXC

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
 
B

Biff

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
 
Top