|
|
Starting
with the First Row
The
following formula returns the sum of every second row from
B2:B10, starting with the first row...
=SUMPRODUCT(--(MOD(ROW(B2:B10)-ROW(B2)+0,2)=0),B2:B10)
Based on the sample data, the formula returns 150. Sample
Workbook |
Starting
with the Second Row
The
following formula returns the sum of every second row from
B2:B10, starting with the second row...
=SUMPRODUCT(--(MOD(ROW(B2:B10)-ROW(B2)+1,2)=0),B2:B10)
Based on the sample data, the formula returns 220. Sample
Workbook |
|
|
