Vlookup and SumIF help

[Asa_123]

I am looking to get the sum of a range of accounts on a seperate tab of the same worksheet.

Basic Example:
The data tab contains the account numbers in column A and the numbers I want to sum are in column J.
(A) (J)
Account Value
740 1 10
740 2 20
740 3 30
740 4 40
740 5 50

What I am looking to do is on the summary tab lookup all accounts between "740 2" and "740 4" and return the sum of those accounts. In this case 90 would be the final value. The actual file is much larger but this is my basic issue.

Thank you!

[DGagnon]

Give this a shot:

=SUMIFS(J1:J5,A1:A5,">=740 2",A1:A5,"<=740 4")

[NBVC]

if the accounts are grouped and in ascending order, this should work:

=SUMIFS(B2:B6,A2:A6,">=740 2",A2:A6,"<=740 4")

or

=SUMIFS(B2:B6,A2:A6,">=" & X1,A2:A6,"<=" & X2) where X1 and X2 contain the parameters

[Haseeb Avarakkan]

Try this,

In K1 & K2 enter the start & end number. If you want to start "740 2" & End is "740 4" enter 2 & 4 respectively, then use

=SUMPRODUCT(SUMIF(A:A,"740 "&ROW(INDIRECT(K1&":"&K2)),J:J))

[Asa_123]

You know I had tried this and I must have been missing a step. Looks like it is working. THANK YOU!