SUMROWS

Sum a range by row in Google Sheets with SUMROWS

Calculations
by
Lucas 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

Calculations
Sum a range by row in Google Sheets with SUMROWS
Output the sum by row of several rows in a table without depending on filling down.
SUMROWS
Lucas A. Browne Dias

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

HomeAboutContact