Sum of range in column

odko221100 

Riny_van_Eekelen has covered the normal database approach of running through the entire list of values filtering out those that do not match the given criteria.  SUMIFS is extremely fast in terms of its execution, SUMPRODUCT less so.

With 365 it is also possible to pass the parameters to a Lambda function and build the bounded calculations one at a time.

= MAP(To, From, LAMBDA(t,f,
      SUM(INDEX(Case, t) : INDEX(Case, f))
  ))

will build the individual ranges and sum them.  It is also passible to go for something more complicated and build an array sum for each calculation using SEQUENCE.

= MAP(From,To,SumSeqλ(Case))

SumSeqλ
= LAMBDA(rng, 
    LAMBDA(f,t, 
      SUM(INDEX(rng, SEQUENCE(1+t-f,,f)))
    )
  )

Perhaps I should build a dataset with 100,000 values and perform some timing runs!

odko221100 Two possible solution. One with SUMIFS. Another with SUMPRODUCT. See which one suits you best. Examples in the attached file.