sumproduct for numeric range

[DumbCluck]

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.

 

[Bob Phillips]

Can you give some examples of expected results?

 

[DumbCluck]

Can you give some examples of expected results?

--
__________________________________
HTH

Bob

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.

 

[Marc]

Tools/Data Analysis/Histogram

You may have to install the addin to get that menu option.