Do Math in Gigasheet

To so many, spreadsheets are for calculations. And these calculations happen in two main ways: doing math on one field, like performing a sum on a column of values, or doing math 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 Artithmetic tool. From the Tools menu, choose "Artithmetic", and then add, subtract, multiple, or divide any two columns together. The results of that new column can then be aggregated, sorted, grouped, or used in any other Gigasheet workflow.

‍