<
<

Calculate Sum

>

Computes the total sum in each row and column.

>

Input

Output

34 Related tools

Video Tutorial?

Table Statistic?

Any Questions?

Computes the total sum in each row and column. Sum is the total obtained by adding all elements together. Read more about addition on Wikipedia https://en.wikipedia.org/wiki/Summation

12 is the sum of the set [2, 4, 6] because 2 + 4 + 6 = 12.

This tool is useful when you need to quickly determine the total of a set of numerical values, such as calculating the total sales or revenue for a given period.

  • Microsoft Excel: SUM
  • Google Sheets: SUM
  • Apple Numbers: SUM
  • Python Pandas: df['column_name'].sum()
  • Related Words: sum, total, aggregate, combine

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.

Related Tools?

Add Two Tables

Add values element-wise for each cell.

addition
Add Two Columns

Add values element-wise for each column.

addition
Apply Addition

Add a specified number to the entre table.

addition
Rolling Sum

Computes the rolling sum of a specified window size for a dataset.

addition
Cumulative Sum

Computes the cumulative sum in a dataset up to each row or column.

addition
Groupby Sum

Computes the sum of values in a dataset grouped by a specified column.

addition
Calculate Difference

Computes the total difference in each row and column.

Calculate Product

Computes the total product in each row and column.

Calculate Quotient

Computes the quotient in each row and column.

Calculate Mode

Computes the most frequent value in each row and column.

Calculate Duplicate Cell Count

Count the number of duplicated cells in each row and column.

Calculate Unique Cell Count

Count the number of unique cells in each row and column.

Calculate Maximum

Computes the maximum value in each row and column.

Calculate Minimum

Computes the minimum value in each row and column.

Calculate Range

Computes the range between minimum and maximum in each row and column.

Calculate Blank Count

Count the number of empty cells in each row and column.

Calculate Non Blank Count

Count the number of non empty cells in each row and column.

Calculate Geometric Mean

Computes the geometric mean in each row and column.

Calculate Harmonic Mean

Computes the harmonic mean in each row and column.

Calculate Mean

Computes the arithmetic mean in each row and column.

Calculate Median

Computes the median value in each row and column.

Calculate Concatenation

Concatenate the values for each row and column.

Calculate Maximum Date

Computes the maximum date in each row and column.

Calculate Minimum Date

Computes the minimum date in each row and column.

Calculate Range Of Dates

Computes the date range in each row and column.

Calculate Quantile

Computes the 2nd, 3rd quantile value in each row and column.

Calculate Covariance

Computes the covariance of all columns against other columns.

Calculate Kendrall Correlation

Computes two column's or row's ordinal association.

Calculate Kurtosis

Computes the tailedness or peakedness in each row and column.

Calculate Pearson Correlation

Computes two column's or row's linear relationship.

Calculate Skewness

Computes the asymmetry of the data distribution in each row and column.

Calculate Spearman Correlation

Computes two column's or row's monotonic relationship.

Calculate Standard Deviation

Computes the standard deviation in each row and column.

Calculate Variance

Computes the variance in each row and column.

<
👉... other 321 tools to save you time
>