sum vlookup until vlookup

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

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 close merge delete