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 |
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 |