I have the following formula =(((C3*B3%) (C4*B4%))*100)/C1: instead of repeat the part ((C3*B3%) (C4*B4%)) for every next cells (e.g: ((C3*B3%) (C4*B4%) (C5*B5%) (C6*B6%)) ), is there a way to write this for a range of indexes?

CodePudding user response：

=100*SUMPRODUCT(C3:C999999,B3:B999999%)/C1