Summing Every nth value in Range (Hindi)

Опубликовано: 05 Август 2020
на канале: Excel Vba Club
212
7

How to sum Every nth Value in Range
Formula:
={SUM(IF(MOD(ROW(INDIRECT("1:"&COUNT(B5:B21)))-1,n)=0,B5:B21,""))}