sumproduct basic help
thanks a lot duke & don!
susan
On Sep 8, 8:55*am, Duke Carey
wrote:
=sumproduct(--(income=.5),household)
"Susan" wrote:
good morning everybody...........
i have 2 columns
col C * * * * * * * * * * col D
# in household * * * *income percent
2 * * * * * * * * * * * * * 50%
1 * * * * * * * * * * * * * 50%
2 * * * * * * * * * * * * * 30%
2 * * * * * * * * * * * * * 60%
2 * * * * * * * * * * * * * 60%
column C's named range is "household". *column D's named range is
"income."
what would be the formula (i believe sumproduct) to count the total
number of people in "household" who have 50% in income? *the total
number of people in "household" who have a 60% "income"?
i've also tried this array formula:
=SUM((Household)*IF((Income="50%"),1)) but i get a *NUM* error.
thank you very much in advance for any help someone can give me.
susan- Hide quoted text -
- Show quoted text -
|