I need a way to tell excel to execute a formula X number of times, and then give me the sum of the results. Is there anyway to do this other than copying the formula X number of times and then adding the values.

I will use dice rolling as an example. Say I have X number of 6 sided dice, I want the sum of X number of the 'RANDBETWEEN(1,6)' formula.

Any thoughts?