| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct basic help
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct basic help
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct basic help
=sumproduct(--(income=.5),household)
"Susan" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct basic help
thanks a lot duke & don!
susan On Sep 8, 8:55*am, Duke Carey wrote: =sumproduct(--(income=.5),household) "Susan" wrote: 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 - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct basic help
=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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct basic help
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 - |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct basic help
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 On Sep 8, 10:37*am, "Don Guillett" wrote: 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 -- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct basic help
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 "Susan" wrote in message ... 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 On Sep 8, 10:37 am, "Don Guillett" wrote: 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 -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| Basic Template | Excel Discussion (Misc queries) | |||
| this is probably very basic | Excel Discussion (Misc queries) | |||
| Basic If | Excel Worksheet Functions | |||
| DV basic help | New Users to Excel | |||
Linear Mode
