SUMROWS

Sum a range by row in Google Sheets with SUMROWS

Calculations
by
Lucas A. Browne Dias
Jul 2

This function allows for summation by row of a large range without using fill-down.

It takes a single argument, the range and outputs the sum by row for each row.

Note: this cheat has the honor of being the "first community contribution" to spread_cheats.

Use the Cheat

How to Add a Cheat to a Google Sheet

Click the Code Box to Copy

Cheat copied to clipboard ✂️👍
/** * Adds all numbers of each column by row. *  Disregards non-number types like strings and dates. * * @param {Array} input - The data to calculate the sum in each row * * @return The sum for each row as a column. * * @customfunction */ function SUMROWS(...array){ try {   //checks if all arguments are of the same size    var sizes = ' '    var check = 0    for (a=0;a

We've built an interactive tutorial in Google Sheets where it's easy to see how the function works. You can read the definition, edit examples, and do some practice examples to verify that you understand how to use the function.

Copy Tutorial View Tutorial Download AppScript Code
Sum any range by row
Lucas A. Browne Dias Lucas A. Browne Dias

Faster and Smarter: A data creative bringing insights and value through analytics.



‍

Related Cheats

Data Generation
Convert a Google Sheets range to JSON with TABLE_TO_JSON
Convert a range to a JSON object with multiple items.
Cyrus Radfar
Cyrus Radfar
Data Generation
Get all combinations from sets in multiple lists in Google Sheets with COMBINE
Get all the combinations
Lucas A. Browne Dias
Lucas A. Browne Dias
Data Generation
Convert a Google Sheets range into URL key & value parameters with TABLE_TO_KV
Prepare correctly encoded URL parameters from a range of data
Cyrus Radfar
Cyrus Radfar
Clean to Type
Add leading "0" other characters before a number or string in Google Sheets with PAD
Create fixed length strings from a number or text input with configurable leading characters.
Cyrus Radfar
Cyrus Radfar
Data Generation
Transform dates to financial half year in Google Sheets with SEMIANNUAL
Convert a range of dates to financial half-year.
Cyrus Radfar
Cyrus Radfar

Want to share a Cheat?

Join us

Be the first to know when new Cheats are posted

Thank you for joining our list. If you'd like to join our community submit this survey.

Oops! Something went wrong while submitting the form. Email us at support@spine.dev

Home About Contact