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