How To

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.

Highlight of aggregation bar in Gigasheet UI

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.

Highlight of aggregations within a Group in Gigasheet UI

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.

Highlight of where Formula function is found within menu  in Gigasheet UI

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.