Sum a range by row in Google Sheets with SUMROWS

CalculationsLucas A. Browne Dias
Jul 7

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
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

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 TutorialView TutorialDownload AppScript Code
Output the sum by row of several rows in a table without depending on filling down.
Lucas A. Browne DiasLucas A. Browne Dias

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

Related Cheats