sumproduct basic help

[Susan]

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

 

[Don Guillett]

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

 

[Duke Carey]

=sumproduct(--(income=.5),household)

 

[Susan]

thanks a lot duke & don!
susan

=sumproduct(--(income=.5),household)












- Show quoted text -

 

[Bob Phillips]

=SUMIF(income,50%,household)

etc.

 

[Susan]

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

susan

 

[Don Guillett]

Susan. One thing that wasn't crystal clear in your post is whether you
wanted to COUNT the number of 50% or SUM the column for those with 50%?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
thanks bob....... just like macros, there's 50 ways to do the same
thing!

susan

 

[Susan]

sorry i wasn't clear - i said "count" but i meant "sum".
i used the sumproduct formula & that worked. "sumif" probably would
have worked also, but i had already done it with the sumproduct.

susan

 

[Bob Phillips]

But SUMIF is SO much more efficient than SUMPRODUCT, which is why I posted
it even though I had seen the SUMPRODUCT offering.

--
__________________________________
HTH

Bob

sorry i wasn't clear - i said "count" but i meant "sum".
i used the sumproduct formula & that worked. "sumif" probably would
have worked also, but i had already done it with the sumproduct.

susan