sum vlookup until vlookup [closed]

asked 2016-03-17 16:00:32 +0100

Alex Vargas gravatar image

This works with AND (;) SUM(VLOOKUP($C4;'01-11'.$C$4:$R$300;11;0);VLOOKUP($C4;'22'.$C$4:$R$300;11;0))

This doesn't work with TILL (:) SUM(VLOOKUP($C4;'01-11'.$C$4:$R$300;11;0):VLOOKUP($C4;'22'.$C$4:$R$300;11;0))

My goal is when I add a new tab between the specified tabs it is included in the sum. Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-01 20:03:55.474431