How to sum a range to a cell based on another cells value

Originally Posted by Cutter

=SUM(keys!B2:INDEX(keys!B:B,Values!B2+1))

Hi Cutter! Thanks for the help/suggestion, however (sadly) I get the same error with that one as I do with this one:

=sum(keys!B2:INDIRECT("B"&$B$2))

error: unknown range name keys!B2

It seems as if using a function call on the second half of the range confuses it. And I just cannot seem to figure out how to encapsulate it properly (single or double quotes, parentheses, etc...).