Table of Contents
The process of summing every nth row in Google Sheets involves using a specific formula to add up the values in a selected range of cells every nth row. This can be done by using the SUMIF or SUMIFS function, where the criteria is set to only include the nth rows. For example, to sum every 3rd row in a column, the formula would be =SUMIF(A1:A10,”=MOD(ROW(A1:A10),3)”,0). This will provide the total sum of all values in the 3rd, 6th, 9th, etc. rows.
Sum Every Nth Row in Google Sheets (With Examples)
You can use the following syntax to sum the values in every nth row in Google Sheets:
=sumif(ArrayFormula(mod((row(A1:A)-row(A1)+1),3)),0,A1:A)
This particular formula sums every 3rd value in column A, starting at cell A1.
The following examples show how to use this syntax in practice with the following column of values in Google Sheets:
Example 1: Sum Every Third Row
We can use the following formula to sum the values in every third row (starting in cell A1) of column A:
=sumif(ArrayFormula(mod((row(A1:A)-row(A1)+1),3)),0,A1:A)
The following screenshot shows how to use this syntax in practice:
The sum of every third row turns out to be 37.
We can manually verify this by taking the summation of every third row:
Sum: 15 + 10 + 3 + 9 = 37.
Example 2: Sum Every Sixth Row
We can use the following formula to sum the values in every sixth row (starting in cell A1) of column A:
=sumif(ArrayFormula(mod((row(A1:A)-row(A1)+1),6)),0,A1:A)
The following screenshot shows how to use this syntax in practice:
We can manually verify this by taking the summation of every sixth row:
Sum: 10 + 9 = 19.
Example 3: Sum Every Third Row Starting at Row 2
We can use the following formula to sum the values in every third row (starting in cell A2) of column A:
=sumif(ArrayFormula(mod((row(A2:A)-row(A2)+1),3)),0,A2:A)
The following screenshot shows how to use this syntax in practice:
The sum of every third row (starting in cell A2) turns out to be 16.
We can manually verify this by taking the summation of every third row, starting at cell A2:
Sum: 8 + 6 + 2 = 16.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I sum every nth row in Google Sheets? Can you provide some examples?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-sum-every-nth-row-in-google-sheets-can-you-provide-some-examples/
stats writer. "How can I sum every nth row in Google Sheets? Can you provide some examples?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-sum-every-nth-row-in-google-sheets-can-you-provide-some-examples/.
stats writer. "How can I sum every nth row in Google Sheets? Can you provide some examples?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-sum-every-nth-row-in-google-sheets-can-you-provide-some-examples/.
stats writer (2024) 'How can I sum every nth row in Google Sheets? Can you provide some examples?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-sum-every-nth-row-in-google-sheets-can-you-provide-some-examples/.
[1] stats writer, "How can I sum every nth row in Google Sheets? Can you provide some examples?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I sum every nth row in Google Sheets? Can you provide some examples?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.