=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