Headline basically states it:

Imagine A1=15, and A2=30

What I want is sum(B15:B30) where 15 and 30 are coming from the other two cells (or another formular for that matter).

How to accomplish this?

>Solution :

Use INDEX:

=SUM(INDEX(B:B,A1):INDEX(B:B,A2))