Five Values that Equal a Sum Value

[ststern45]

Hi Everyone,
Happy New Year 2025

I have a set of 30 values below:
There are duplicate values in the list below. Example: 1, 2, 3 etc.
The minimum value total is 5 (1,1,1,1,1) and the maximum equal 73 (10,11,12,16,24)
So the range is from 5 to 73.

I would like to calculate how many 5 number values would equal sum of 5, 6, 7, .... 73

Thank you!!

1
1
1
1
1
2
2
2
2
3
3
3
3
4
4
5
5
5
5
5
6
6
7
8
8
10
11
12
16
24

 

[ststern45]

Thank you Stephen for the reply and the code.
I will run this tomorrow morning.
Thank you again.
BTW how long did it require to create the sets from your post?

 

[StephenCrump]

BTW how long did it require to create the sets from your post?

On my machine, the code takes around 0.05 to 0.1 seconds.

 

[ststern45]

Thank you again Stephen.
The code works perfectly.