horizontal lines
Gigasheet Primary logo

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. 

Aggregation Bar at the bottom of each sheet
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. 

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. 

Use the Arithmetic options to perform math across columns

Related Resources

Thousands of individuals & teams use Gigasheet.

Join Them

Do Math in Gigasheet

How To...