Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct for numeric range
my data:
A B C -2500 -2000 250 -1750 575 -1500 -32175 -1250 2466 -1000 375 -750 -1176 -500 1577 -250 1683 0 -444 250 1321 500 -421 -499 I want to count frequency distribution of column A..the occurences that fall in the ranges of column B. Because of the negative values, I am having difficulty getting the sumproduct and countif to work. probably my syntax. thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct for numeric range
Can you give some examples of expected results?
-- __________________________________ HTH Bob "DumbCluck" wrote in message ... my data: A B C -2500 -2000 250 -1750 575 -1500 -32175 -1250 2466 -1000 375 -750 -1176 -500 1577 -250 1683 0 -444 250 1321 500 -421 -499 I want to count frequency distribution of column A..the occurences that fall in the ranges of column B. Because of the negative values, I am having difficulty getting the sumproduct and countif to work. probably my syntax. thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct for numeric range
"Bob Phillips" wrote: Can you give some examples of expected results? -- __________________________________ HTH Bob "DumbCluck" wrote in message ... my data: A B C -2500 -2000 250 -1750 575 -1500 -32175 -1250 2466 -1000 375 -750 -1176 -500 1577 -250 1683 0 -444 250 1321 500 -421 -499 I want to count frequency distribution of column A..the occurences that fall in the ranges of column B. Because of the negative values, I am having difficulty getting the sumproduct and countif to work. probably my syntax. thanks in advance. In column "C", I expect -2000 2, -1250 1, -500 3, 250 2, 500 1, 1250 1, 1500 2, & 2000 1. I have been getting correct counts for some of the ranges, but not all. thanks again. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct for numeric range
Tools/Data Analysis/Histogram
You may have to install the addin to get that menu option. "DumbCluck" wrote in message ... "Bob Phillips" wrote: Can you give some examples of expected results? -- __________________________________ HTH Bob "DumbCluck" wrote in message ... my data: A B C -2500 -2000 250 -1750 575 -1500 -32175 -1250 2466 -1000 375 -750 -1176 -500 1577 -250 1683 0 -444 250 1321 500 -421 -499 I want to count frequency distribution of column A..the occurences that fall in the ranges of column B. Because of the negative values, I am having difficulty getting the sumproduct and countif to work. probably my syntax. thanks in advance. In column "C", I expect -2000 2, -1250 1, -500 3, 250 2, 500 1, 1250 1, 1500 2, & 2000 1. I have been getting correct counts for some of the ranges, but not all. thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why input range contains non-numeric data? | Excel Discussion (Misc queries) | |||
Sort numeric range and insert gaps | Excel Discussion (Misc queries) | |||
How do I loop a range of cells until I get a numeric value? | New Users to Excel | |||
SUMPRODUCT by Date (numeric) value | Excel Worksheet Functions | |||
How do i check if something non numeric is in a range & return'Y' | Excel Worksheet Functions |