Dynamic arrays in Excel have transformed how running totals are calculated by row, ... Running totals can become complex when data isn’t ordered alphabetically or follows specific regional patterns.

You can also try using Excel’s built-in Evaluate Formula feature to review array formulas. Here’s how you can do that: First, select the problematic cell and look into its formula bar.