combinations in excel

[michaelsmith559]

How would I calculate and list in excel the number of combinations that equal a given average? For example, how many ways can each of these values be used together to equal $75?
Values: $25, $30, $40, $50, $75, $100.
So obviously, $50 & $100 used 1 time each average $75.
How can I show how many combinations in total equal $75 & how can I list how many times the values are used together to equal that average? Thanks.

 

[michaelsmith559]

Is this the kind of result you are expecting:

Book1
	A	B	C
1	25		75 Average: 75
2	30		50-100 Average: 75
3	40		50-75-100 Average: 75
4	50
5	75
6	100
Sheet1

If 25 can occur 6548 times, 30 occur 2856 times, 40 occur 3045 times, 50 occur 2938 times, 75 occur 569 times, and 100 occur 606 times; how many ways can these values combine to average out to 75?

Or does the way you did it account for all combinations that would come to that average?

I misunderstood the problem you presented. Sorry 'bout dat.

The more I think about it you may be right. Only 3 ways average out to 75. You could get 75, 50 & 100, or 100 & 50. I'll check and see if this works.