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 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.