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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List items based on the count given 4
Frequency on two dimensions 9
Counting frequency in unsorted data 2
Frequency of Words (Array of 50+ words) 0
Counting for frequency 2
Mutiple conditions formula to assign segmentations and coverage 0
Multi-demensional frequency distribution 4
Frequency of date 4

Top