Link to home
Create AccountLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

asked on

Excel Easy Formula help


I need help with simple formula in the attached workbook ,

previously I got help with the similar formula 

this time, I want it to consider the product and the sequence as well. so the dynamic sum aggregated total should be based on the rank of sequence from smaller to greater. please see the example and then you will know what is needed.

thank you very much.
Avatar of krishnakrkc
Flag of India image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Flora Edwards


Thank you Kris.

but the formula did not work.  in E5 it gave me 1 and continuously in other rows as well same 1 and then in F5 copied down duplicated sum.  did not work. perhaps there is glitch in formula?
Thanks a lot Kris.  =SUMIFS($C$5:$C$22,$A$5:$A$22,A5,$E$5:$E$22,"<="&E5)  worked without any helped column

I changed the E column to B.