Function for Progressive sum for multiple conditions in column and row

[pavanbhoyar]

Hello,
Refer attached file for sample data and desired result.

I am looking for formula which will give me desired result of progressive sum for the conditions matching against columns and row.

Thanks in advance.

Best Regards.!

[shank_mis]

In Cell C9:

Please Login or Register  to view this content.

Confirm with Ctrl + Shift + Enter

Please hit the "Add Reputation" button if you liked the answer.

[pavanbhoyar]

Thanks.! It worked for me.

Reputation added.!

[Ace_XL]

Non-array alternative

=SUMPRODUCT(($E$4:$E$7=$C$3)*($F$4:$F$7=$C$4)*($G$3:$R$3>=$C$5)*$G$4:$R$7)