Sum one column to the right with a Small function

[jeffreybrown]

How do I get the offset of this formula to return the sum of column F after establishing the four smallest numbers in column E?

=SUM(SMALL(E1:INDEX(E:E,MATCH(BigNum,E:E)),{1,2,3,4}))

Also, on the array part for the smallest four, how can this be converted so it looks at cell G4 which contains the number of smallest numbers to look for. In this case, G4 contains the number 4.

[jeffreybrown]

Well that was silly. I don't need the offset of column E, I just look at the column F for the top x, but I can't seem to find how I can make the top x variable based off of the contents from cell G4.

G4 contains the number 4, so how to incorporate that number into...

=SUM(LARGE(F1:F20,{1,2,3,4}))

...so it can be the top 4

Any thoughts?

[jeffreybrown]

Ok I got it.

I had this...

=SUM(LARGE(F1:F20,ROW(INDIRECT("1:"&G4))))

...and it wasn't working until I realized it had to be commited with the Ctrl + Shift + Enter.