You do not need the array formulas sum or sumproduct for this. Look in the
help index for COUNTIF


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Susan" wrote in message
...
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