Adding criteria to "sumproduct of two columns until sum of 1st column gets to a set value"

[rustam.takutdinov]

Have a formula which sumproduct two columns until sum of consecutive cells from 1st column gets to or just below a set value. Need to add multiple criteria to this formula based on other adjacent columns. Spreadsheet attached.

[oeldere]

Not sure this is what you want.

Try pivot table (see the attached file).

[rustam.takutdinov]

would like to have an CSE formula, no pivots and vbs

[oeldere]

I'm interested why you don't want pivot tables?

I'm interested why you don't want VBA (I think you mean that instead of vbs)?