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

asked on

Excel Easy Formula help

Hello EXCELERS!

I need help with simple formula in the attached workbook ,

previously I got help with the similar formula https://www.experts-exchange.com/questions/28566529/Excel-Easy-Formula-help.html?anchorAnswerId=40455591#a40455591 

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.
EE.xlsx
ASKER CERTIFIED SOLUTION
Avatar of krishnakrkc
krishnakrkc
Flag of India image

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

ASKER

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.