How to calculate all possibilities

This is combinatorics. I think I understand your question.

Think of it this way. You have an array and each element can either contain a stone or a divider to the next bag. That would require (stones+bags-1) elements to handle all possibilities. That is, you can split the stones up into the number of bags by using (bags-1) dividers. So, how many ways are there to place the (bags-1) dividers within that array of size (stones+bags-1)? =COMBIN((stones+bags-1),(bags-1))

Per your example above, but re-written with
o=stone
l=divider

oooll
loool
llooo
oolol
oollo
olool
loolo
olloo
loloo
ololo

For 3 bags and 3 stones: COMBIN(5,2) = 10. For 4 bags and 8 stones, COMBIN(11,3)=165.

As for showing them, that would require some VBA. You should post in that group. I'd probably use my example as a basis for an algorithm.