everybody

I am attaching the spreadsheet with an example & explanation: I was able to sum from start to some specific value, however I want to sum up values between 2 voluntarily selected rows based on set criteria.

CodePudding user response：

A basic non-array formula solution:

=sum(index(B:B,match(C8,A:A,0)):index(B:B,match(C9,A:A,0)))