Flora Edwards

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

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

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

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.

I changed the E column to B.

ASKER

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?