Skip to main content
4 events
when toggle format what by license comment
Jan 23, 2021 at 11:38 comment added High Plains Grifter This is very useful for someone like me who just wants a way to do it, without having to understand! If you don't mind the volatility of the OFFSET() function, you can make this dynamic using a named range. For eg I made a range called DiceSize to hold the number of sides and put the first "1" probability in B23. I used a dynamic named range called KingSum which refers to =OFFSET('Dice Rolls'!$A$22,-1*DiceSize,,DiceSize,1). I could then used the formula =SUM(OFFSET(KingSum,ROW(A1),COLUMN(A1)))/DiceSize in Cell C23, dragged all over a large area to give a table reliant on DiceSize.
Jul 28, 2014 at 2:19 history edited Glen_b CC BY-SA 3.0
edited because Excel's AVERAGE works differently now, decided to add some images
Jul 28, 2014 at 2:12 history edited Glen_b CC BY-SA 3.0
edited because Excel's AVERAGE works differently now, decided to add some images
Oct 15, 2010 at 6:19 history answered Glen_b CC BY-SA 2.5