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