SOLVED

New Contributor

# replace part of formula

I have formula like this

=SUMPRODUCT(LOOKUP(MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1),P1:P22,O1:O22))

=SUMPRODUCT(LOOKUP(MID(B3,ROW(INDIRECT("1:"&LEN(B3))),1),P1:P22,O1:O22))

what i went is copy this formula  to many lines and change the B2 by incremental like b3,b4,b5 but leave  this part P1:P22,O1:O22 the same for all records

can anyone help ?