way to sum numbers down the list accroding to a value in a cell

Hello,

If I have the following values in cell A1:A5
34
54
56
76
34

and the following value in cell b2: 2

Now in this case I need to sum to first 2 # in the list since the value in B2 is = 2. If the value is 3 then I will need to sum 34,54,and 56. If the value is 4 I will have to sum the first 4 numbers.....and so on. How can I do that? Thank you

Thank you VBA Noob. That worked perfectly