Trying to sum values along a table's hypotenuse

Hello - long time lurker!

I'm trying to add up values along essentially a hypotenuse from a pivot table (see screenshot and attached).

I have manually entered a basic formula similar to what is in attached spreadsheet in the past but my table on this new project is too big.

Any ideas on a lightweight formula that I can use in column B and drag down? Was thinking about some sort of offset but couldn't make it work.

Screen Shot 2020-07-17 at 1.52.02 PM.png