Excel Dynamic Range like concatenate, calculated row

Question

How do i find ranges in excel i want to make dynamic ranges based on my current row position. i've already tried below code

=SUMIF(B5:B(ROW()-1), "<> ", E5:E(ROW()-1))

Answer 1

INDEX is likely your best bet.

=SUMIF(B$5:index(B:B, ROW()-1), "<>", E$5:index(E:E, ROW()-1))