How to sum every n rows in excel

First select cell E2.

Enter the formula =SUMPRODUCT((MOD(ROW(A2:A10),2)=0)*B2:B10) in the edit bar.

Press the "Enter key" to enter.

The universal formula can be directly applied to the template, the formula is =SUMPRODUCT((MOD(ROW(data area),R)=0*1,data area).

Recommended related tutorials: excel tutorial

The above is the detailed content of How to sum every n rows in excel. For more information, please follow other related articles on the PHP Chinese website!