# Formula to cumulative sum.

Formula to cumulative sum by rank order and event order.
Thanks
Ian
CumProbFormula.xlsx
###### Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Business Systems Analyst , ex-Senior Application EngineerCommented:
I quite don't understand your statement of:

>>Sum of probs in rank order for each event

Do you want to make a sum based on unique Event ID AND Prob-Rank ? If yes, you always have that in your original data, pls explain further...
retiredAuthor Commented:
Hi Ryan,
Probably the best way to understand is to look at the figures I have entered in Column D
of the spreadsheet that was attached. It will soon become clear.
Thanks
Ian
Business Systems Analyst , ex-Senior Application EngineerCommented:
ok... in D2, try use formula:
``````=SUMIFS(\$B\$2:\$B\$12,\$A\$2:\$A\$12,"="&A2,\$C\$2:\$C\$12,"<="&C2)
``````
and drag down the formula accordingly.
Business Systems Analyst , ex-Senior Application EngineerCommented:
example as attached.
CumProbFormula_b.xlsx
Commented:
hey racepro

put this formula in column D from second row, see attached.

=SUMIFS(\$B\$2:\$B\$12,\$A\$2:\$A\$12,A2,\$C\$2:\$C\$12,"<="&C2)
CumProbFormula--1-.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

retiredAuthor Commented:
Hi Guys,
Both solutions do the trick.
There is a slight difference between the two as below.
=SUMIFS(\$B\$2:\$B\$12,\$A\$2:\$A\$12,"="&A2,\$C\$2:\$C\$12,"<="&C2)
=SUMIFS(\$B\$2:\$B\$12,\$A\$2:\$A\$12,A2,\$C\$2:\$C\$12,"<="&C2)
But both work
Thanks a million !!
Ian