How To

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.

Aggregation Bar at the bottom of each sheet

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.

Aggregations by group and subgroup

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.

Use the Arithmetic options to perform math across columns

Similar posts

Thousands of individuals & teams use Gigasheet.

Join Them.
No Code
No Database
No Credit Card
Sign Up Today, Free Forever

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.