Sum a Running String of Cells based on Values in Another Column

[LtSplinter]

Oof even wording a title was difficult let alone google this.

The cost in column F is ever increasing after the first 5.

The amount needed each time varies.

I need a formula that will take the value in A2 (9) and sum the first 9 values in column F. That same formula would then take the value in A3 (3) and sum the next 3 values in Column F. Next one would be A3 (7) the formula would count the cost of 13-19 which equals 9100

The color is just for this post for visual effect of what i'm pointing out and how they are relating to each other.

This feels like a COUNT/COUNTIF/SUMIF nested formula but i just can't wrap my head around the order. Thanks for your help.

*Sorry about the image size...don't know how to resize it as an attachment...

2021-04-01 16_57_17-Book1 - Excel.png

[Pete_UK]

You can use this formula in B2:

=SUM(F2:INDEX(F:F,A2+1))

and this one in B3:

=SUM(INDEX(F:F,SUM(A$2:A2,2)):INDEX(F:F,SUM(A$2:A3)+1))

You can copy the formula from B3 into B4.

Hope this helps.

Pete

P.S. Next time, don't bother showing a picture of a worksheet (which we can't work with) - instead, attach a sample workbook by following the guidance in the yellow banner at the top of the screen.

[Phuocam]

Or try this in B2:

=SUMIFS(F:F,E:E,">"&SUM($A$1:A1),E:E,"<="&SUM($A$1:A2))

[Phuocam]

Another way:

=SUM(OFFSET($F$2,SUM($A$1:A1),0,A2,1))