I need to calculate running totals of sum events. The “score” calculations are nested if functions that will return #NUM! until values are placed in the distance columns. The total column represents a running total.
Sample image of workbook

I’ve tried setting the Total with SUM, SUMIF with the middle value >0, i’ve tried sumif disregarding NA, but I can’t seem to find the right formula to do a running total and ignore the #NUM! values.SUM with Nest If and IF NA