Thread
:
sumproduct basic help
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
sumproduct basic help
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
"Susan" wrote in message
...
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 -
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett