Counting ranges

[Luther]

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

 

[merjet]

MIN(D), MAX(D), SUM(E:E)

Put row numbers after column letters if desired.

Hth,
Merjet

 

[Luther]

Thank you for your response. However, I am looking at making this more
flexible; there are more ranges to account for, like 5-8 where the number of
values will not always be constant.

Example:
1. 5,6,7,8
2. 5,7,8