sumproduct for numeric range

  • Thread starter Thread starter DumbCluck
  • Start date Start date
D

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 said:
Can you give some examples of expected results?

--
__________________________________
HTH

Bob
Click to expand...
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.
 
Back
Top