Hello,

I have a range of numbers in 2 columns; 1st column are the observed values
and the 2nd column are the counts. What I need to do is create ranges for
those 2 columns and count them. The example below show this:

Duration Freq
2 4
3 4

So the result should be that

Column D = 2-3 (range of numbers)
Column E = 8 (sum of the counts for each)

Is there a formula that can accomplish this, please?

Thank you in advance,
Luther