CODEWITHSUNDEEP
excelexcel-2007
Endrik
Endrik

Reputation: 606

Excel Dynamic Range like concatenate, calculated row

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))

Upvotes: 1

Views: 79

Answers (2)

user4039065
user4039065

Reputation:

INDEX is likely your best bet.

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

Upvotes: 1

Gordon K
Gordon K

Reputation: 824

Another approach is to put the formula

=SUMIF(B$5:B5,"<> ", E$5:E5)

In the column you are interested in on row 6 and then copy down the column.

Upvotes: 1

Related Questions