@ DDL -
=SUM(IF(ROW(A1:A100)<=B3,RANDBETWEEN(1,6)))
- you're saying that this only invokes the Rand() once??