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.

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.

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.

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.