thanks bob....... just like macros, there's 50 ways to do the same
thing!
:)
susan


On Sep 8, 9:27*am, "Bob Phillips" wrote:
=SUMIF(income,50%,household)

etc.

--
__________________________________
HTH

Bob

"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- Hide quoted text -

- Show quoted text -