<
<

Rolling Sum

>

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

>

Input

Output

28 Related tools

Video Tutorial?

Table Statistic?

Any Questions?

Computes the rolling sum of a specified window size for a dataset. 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.

Useful in time series analysis where we need to understand the cumulative effect over a moving window, such as moving annual totals.

  • Microsoft Excel: SUM
  • Google Sheets: -
  • Apple Numbers: -
  • Python Pandas: df['column_name'].rolling(window=n).sum()
  • Related Words: calculate rolling sum, sum over a window

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
Calculate Sum

Computes the total sum in each row and column.

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
Rolling Quotient

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

Rolling Product

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

Rolling Difference

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

Rolling Duplicate Cell Count

Count duplicate cells within a specified window size for a dataset.

Rolling Mode

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

Rolling Unique Cell Count

Count distinct cells within a specified window size for a dataset.

Rolling Maximum

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

Rolling Minimum

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

Rolling Range

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

Rolling Blank Count

Count empty cells within a specified window size for a dataset.

Rolling Non Blank Count

Count non-empty cells within a specified window size for a dataset.

Rolling Geometric Mean

Computes the rolling geometric mean of a specified window size for a dataset.

Rolling Harmonic Mean

Computes the rolling harmonic mean of a specified window size for a dataset.

Rolling Mean

Computes the rolling mean (average) of a specified window size for a dataset.

Rolling Median

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

Rolling Concatenation

Concatenate the values within a specified window size for a dataset to form a single string.

Rolling Percent Difference

Computes the rolling percentage difference of a specified window size for a dataset.

Rolling Quantile

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

Rolling Kurtosis

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

Rolling Skewness

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

Rolling Standard Deviation

Computes the rolling standard deviation of a specified window size for a dataset.

Rolling Variance

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

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