Sum Every Nth Column in Excel

In this video, we’ll look at how to sum the values in every 2nd, 3rd, 4th, or nth column. In addition to being able to sum every nth column within your starting dataset, this function grows automatically to continue summing every nth column as you add additional data.

Thanks for watching.

TIMESTAMPS:
====================
0:00 Introduction
0:32 Objective
0:57 Equation
2:01 Explaining how the equation works
8:14 Adding additional data

EXCELSMITH LINK:
====================

[matlholelosaba]

Thank you.
Needed a solution to place a number at every nth column. SEQUENCE was giving me a challenge. I incorporated your solution into SEQUENCE and it worked wonders.
=IF(MOD(SEQUENCE(, 240, COLUMN($C$1), 1), COUNT(COLUMN($C$1:$E$1)))=1, B8, 0)
Row 1 is =SEQUENCE(, 240, 1, 1)
B1 Contains the number I want to be repeated every COUNT(COLUMN($C$1:$E$1)).

[reenakuruvilla]

Hello Justin, Thank you for the great video. It helped me to sum the alternate columns in my table. I have a model where there are multiple columns [36 columns] - Actual, Budget and Variance for 12 months. Is it possible to create a dynamic model where the sum total of the YTD can be based on criteria? For ex- Criteria YTD Oct Actual [from a drop down list] - Captures sums of Jan-Oct, but ignore Nov-Dec in the range ? with the current formula, its sums everything in the range. Appreciate a reply.

[mohammadtoolbar]

this is one of the most vodoo magic formulas I have ever used. You are a genius!!

[agnideepmukherjee]

Amazing video, thanks.
I would need another extension of this formula.

I need the sum of the QTRs, however for a particular product lead. How can I put filter on both row and column at the same time?
Appreciate your help.

[xxdcixx]

Used this in Excel and worked perfectly for me! Thanks!

[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

[albiefiaroque]

Can you type the formula here and a short description what it does

[ritiksinghal]

i tried this in google sheets its not working there

[martinbyrne]

i tried this on excel, went over the formula a few times it does no seem to work, :(

[LaloinLondon]

ALTRNATIVE SOLUTION: =SUMIF($F$7:$Q$7, "*TOTAL*", F9:Q9)