Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct - I think - Counting occurances that fall into criteria
Howdy y'all,
I would like to use the sumproduct command, I believe, to count the cells that have ranges of income levels in a certain county. I have a large amount of data sorted by counties with hypothetical people in there. Each individual hypothetical person has their gross income level in a field. I would like to break down the income levels by $10k increments and I need sumproduct to count the occurances of for example, hypothetical residents of Adams County with income levels betweek $1k and $10k. No idea how to do this. Any help will be appreciated. -- Chris Kaiser Apprentice Excel Ninja |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct - I think - Counting occurances that fall into criteria
Column A = Name
Column B = Income Column C - County County to look in entered in D1 Lower income level in D2 Upper income level in D3 =Sumproduct((C2:C1000=D1)*(B2:B1000=D2)*(B2:B1000 <=D3)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ckemtp" wrote in message ... Howdy y'all, I would like to use the sumproduct command, I believe, to count the cells that have ranges of income levels in a certain county. I have a large amount of data sorted by counties with hypothetical people in there. Each individual hypothetical person has their gross income level in a field. I would like to break down the income levels by $10k increments and I need sumproduct to count the occurances of for example, hypothetical residents of Adams County with income levels betweek $1k and $10k. No idea how to do this. Any help will be appreciated. -- Chris Kaiser Apprentice Excel Ninja |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells that fall within a certain date range | Excel Discussion (Misc queries) | |||
Counting 7 and 8 occurances | Excel Discussion (Misc queries) | |||
Counting if numbers fall within a specified range | Excel Discussion (Misc queries) | |||
COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions |