# How to Use Array Formulas in Coda

> To use array formulas in Coda, open your document and navigate to the target table. Click the plus icon to add a new column, select the Formula option, and enter your formula in the editor to process multiple monthly expense values collectively and automatically update calculations when data changes.

Canonical: https://livedemo.ai/tutorials/how-to-use-array-formulas-in-coda/
Apps: Coda
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a50d0ab56e05a00ffd897/preview?step=1

## Steps

1. Open your Coda document.
2. Navigate to the table where we'll work with array formulas to transform your financial data calculations.
3. Click the + icon to add a new column to your table.
4. Select the 'Formula' option from the dropdown menu to access Coda's formula capabilities.
5. In the formula editor, we'll create an array formula that processes multiple values at once.
6. Let's create a formula that sums values in an Array - no need to SUM things up one by one! (See what I did there?)
7. These values represent your monthly expense categories. The array formula will process them collectively.
8. Now, your array formula automatically updates calculations whenever any values change.