Sum Every Nth Row in Excel

In this video, I’ll show you how to build an equation to sum every 2nd, 3rd, 4th, nth row in a column. This equation works even when the data doesn’t begin on the first row of the spreadsheet.

Additionally, this equation can be modified to perform other actions on every nth row. Simply replace SUM at the beginning of the equation with other formulas such as COUNT(), AVERAGE(), or STDEV(), for example.

GENERIC EQUATION (must be submitted as an array formula using CTRL+SHIFT+ENTER):
=SUM(IF(MOD(ROW(data_column),COUNT(ROW(space_to_second_to_sum)))=MOD(ROW(first_cell_to_sum),COUNT(ROW(space_to_second_to_sum))),data_column))

TIMESTAMPS:
====================
0:00 Introduction
1:45 Equation
4:25 Expanding the Equation
5:38 Wrap up

DOWNLOAD EXCEL FILE:
====================

MICROSOFT LINKS:
====================

[alexandruagapi]

I wasted a lot of time, many many many hours, to find the right formula for some merged rows... NO formula worked until i find yours.. GREAT!!! .. YOUR FORMULA IT WAS THE UNIQUE FORMULA THAT WORK PERFECTLY in any situation and any combination of merged rows.. I will tattoo it on my neck.. :))) THX MEN!!! ... I will watch on all your videos.

[YoucefYoucef-ftce]

I like you presentation thank you sir for this job

[mntk]

Not saying that this's the easiest formula to do, until I follow through the summary at 5:10 then it works like a charm! Thank you very much!!

[kamransiddiqui]

Thank you very much. Much appreciate, if you could share the worksheet in the description box, for further understanding. Regards.

[hiteshkothari]

Can you help me calculate the total sum from the sum-product formula?

S.NO EXPENSES HEAD Bank 1 Bank 2 Bank 3 Bank 4 Bank 1 Bank 2 Bank 3 Bank 4 Bank 1 Bank 2 Bank 3 Bank 4

I need total of BANK 1 by sumproduct formula

[Jerbs]

This appears to have a limit to the range it can work with. I have 17525 rows and want to sum every 49th row, but this only counts the first 18 (or so) entries and then seems to stop. Is there a method of working with a large range?