Do Math in Gigasheet

To so many, spreadsheets are for calculations. But what happens when you need to do calculations that are too big for normal spreadsheets like Excel and Google Sheets? Enter Gigasheet. In Gigasheet these calculations happen in two main ways: doing math on one field, like performing a sum on a column of values, or doing math with formulas across fields, like finding the outstanding difference between invoiced amount and received amount.

Gigasheet allows you to do both.

To perform a calculation on a single field, use Gigasheet aggregations. The Aggregation bar displays by default at the bottom of each sheet. Based on the type of data in the column, you'll have different aggregation options. With integers, you'll see options like "Sum" and "Average". With text strings, you'll see "Percent Empty" and "Percent Unique".

Using this aggregation bar, you can quickly calculate various all-column values without writing a single formula.

Aggregations can also be done on groups. After grouping a field, the aggregation options available at the bottom become available in each value box. This even applies to sub-groups.

To perform calculations across columns, use the Formula builder. From the Functions menu, choose "Formula", and then add, subtract, multiple, or divide any columns together. The results appear in a new column that can then be aggregated, sorted, grouped, or used in any other Gigasheet workflow. For more details on formulas, check out our support docs.

‍