vlookup as part of the sum function

[jbusby825]

i have the following table:

Table 1

	A	B
1	payment 1	375
2	payment 2	370
3	payment 3	365

<tbody>
</tbody>

I want to create summary in another sheet that if I put "2" then i want to sum both the 375 + 370, but if I put 3 then sum all 3 figures. I was trying to do something along the lines of

	A	B
1	payment 2	=sum('Table 1'!b1:vlookup(a1,'Table 1'!a1:b3,2,false))

<tbody>
</tbody>

I got an error on this so obviously i'm not doing something correctly.

How would i be able to accomplish this? (obviously this is on a much grander scale as it has about 360 rows and 11 columns in my real table)

Thank you!
jbusby825

 

[Special-K99]

=SUMIF(A1:A3,"<=Payment "&C1,B1:B3)

where C1 is 1 2 or 3

 

[Joe4]

How about just something like:

[COLOR=#333333]= 'Table 1'!b1 + vlookup(a1,'Table 1'!a1:b3,2,false)[/COLOR]

 

[DanteAmor]

How about:

=SUM(INDIRECT("'Table 1'!B2:B" & MATCH(A2,'Table 1'!$A$1:$A$1000,0)))

 

[jbusby825]

@Special-K99 this worked perfectly. Thank you!

 

[jbusby825]

@Joe4 this would only add up the 1st item and then the item from the vlookup. i was needing to add up from the 1st item THRU the item in the vlookup. the sumif formula above worked great. thanks for input.

 

[Joe4]

this would only add up the 1st item and then the item from the vlookup. i was needing to add up from the 1st item THRU the item in the vlookup.

My apologies. I misread the question.