Skip to content
Gallery
Coda guide for spreadsheet users
Share
Explore
Formula guides

icon picker
Summary Formulas

Loading…


info

How to do the equivalent of TABLE CALCULATORS in Coda

Excel or Google Sheets:
image.png

Coda:
In Coda there are two ways of summarizing values from a table. You can have a Canvas Formula which will be separate from the table. And you can also have in table summary of the column.

Canvas Formula:
image.png





Result:
image.png

In-table Summary:
image.png
Result:
image.png
info

Formula side-by-side

image.png

Parameters
Summary in Excel
Summary in Coda
1
Dataset
Cell references (e.g. A2:B4)
Name of the table (e.g. “Stuff”)
2
Range to summarize
A range of values or a column (e.g. B2:B4 or “Cost”)
Name of the column you want to summarize (e.g. “Cost”)
3
Sum Function
A function to summarize the column or range (e.g. sum)
A function to summarize the column or range (e.g. sum)
There are no rows in this table

info

High-level differences between Summary Formulas and Canvas Formulas

Some of the main differences between Table Calculators in Google Sheets/Excel vs. Summary Formulas in Coda include:
Cell references vs names of tables/columns - Instead of having to reference a specific cell of a range of cells to reference a list of values, you can start a formula by typing the name of a table or column in the formula builder
Dots vs. parentheses - In addition to using parentheses in formulas, you can use dots as well. The dot “.” allows Coda to quickly auto-complete the name of the column you want to return from the lookup table. sum(table.column) is interchangeable with table.column.sum()
In table summary and canvas formula - In Coda, you have the ability to both summarize your list of values in the table you are referencing and use a canvas formula to summarize your range of values
Check out on Table Calculators in Excel/Google Sheets and Summary Formulas in Coda.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.