Question: how to calculate a running percentage total in excel?
Answer: In cell C2, enter the formula =B2/$B$18. ...  Copy C2 to just the next cell, either by dragging the fill handle down one cell or using Ctrl+C and then Ctrl+V. Press F2 to edit cell C3. Type a plus sign and touch cell C2. ...  Double-click the fill handle in C3 to copy this formula down to all the other cells.