Youtor
Sum Every Nth Row in Excel
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=apqRbY_D9nY
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: • ==================== • https://docs.google.com/spreadsheets/... • • MICROSOFT LINKS: • ==================== • COUNT(): https://support.microsoft.com/en-us/o... • IF(): https://support.microsoft.com/en-us/o... • MOD(): https://support.microsoft.com/en-us/o... • ROW(): https://support.microsoft.com/en-us/o... • SUM(): https://support.microsoft.com/en-us/o... • MICROSOFT KEYBOARD SHORTCUTS: https://support.microsoft.com/en-us/o...
#############################
