vlookup as part of the sum function

[jbusby825]

i have the following table:

Table 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]payment 1[/TD]
[TD]375[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]payment 2[/TD]
[TD]370[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]payment 3[/TD]
[TD]365[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]payment 2[/TD]
[TD]=sum('Table 1'!b1:vlookup(a1,'Table 1'!a1:b3,2,false))[/TD]
[/TR]
</tbody>[/TABLE]

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.