Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: frequency in two dimensions?
2 views
Skip to first unread message
Biff
Nov 21, 2006, 5:14:30 PM11/21/06
to
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" <Hu...@discussions.microsoft.com> wrote in message
news:8D680600-95C4-443C...@microsoft.com...
>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
0 new messages