Excel Forum
Similar Content
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Filter Data in Excel to Display Records that Contain a Value Between Two Values - AutoFilter.
Macro: This free Excel macro filters data to display only those records or rows that contain a va...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions


See how to SUM every Nth value using SUMPRODUCT, MOD and ROW functions. See two alternative formulas, each for a different situation:
1.SUMPRODUCT & MOD & ROW for range starting in cell A1
2.SUMPRODUCT & MOD & 2 ROW functions for range starting in any cell
Sum every 3rd, 26th, etc. value.





Got a Question? Ask it Here in the Forum.