Link to home
Start Free TrialLog in
Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland

asked on

combine sum index formula with start end index function

Hi,
I would like to combine a start and end Index formula with a sum probability formula
to greatly speed up the calculations.
Both formulas are displayed on the attached spreadsheet.
Many Thanks
Ian
Sum-Probabilities-to-one-Version-3.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ian Bell

ASKER

Sorry for the delay in replying, let me get back to you tomorrow on this Saqib
Thanks
Ian
Wow...I was racking my brains trying to rerecall this formula and eventually discovered that is was about two years ago.
Just tidying up a couple of open questions.  Formula worked well.
Thanks