Each column's "total" row is just the sum of the cells above it. The formulas should be like so:
. . .
Then, each cell in the second column will be an
When you copy and paste the formula into other cells, Excel will leave that portion of the formula alone since the dollar signs make the cell references absolute rather than relative.
It is not necessary to calculate the sums for this; for example, using B6, =SUM(C6/Z6)/SUM($C$6:$Z$24) would also work. However, I kept it as is since I figured the totals by themselves could be instructive to you.
If you need more or fewer columns, feel free to change the Z, which assumes that your data extends up to column Z.
I believe there is a technique to support any amount of columns, but I'm not certain right now. I'm sure you can find it on this site or Google.
overall drop % (for all data). You calculate it by dividing the sum of that row by the sum of all rows:
. . .