sumproduct basic help

S

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
 
D

Don Guillett

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

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
 
S

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top