익명 07:47

Variable dice simulation total

Variable dice simulation total

What my screen looks like I've created dice in Excel, but now I'm trying to calculate the value of the dice based on x amount of dice. ie if I want 3d6, it only pulls values of 3 dice instead of all 15. Would I use COUNTIF or how else do I go about this?

Edit: I have no clue how to share an excel file, if someone tells me how I will.



Top Answer/Comment:

You could try using the SUM function on a selected range for just the dice you want to add. You might also want to organize data in rows or columns to make it easier.

상단 광고의 [X] 버튼을 누르면 내용이 보입니다