Ian Bell

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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Wow...I was racking my brains trying to rerecall this formula and eventually discovered that is was about two years ago.

ASKER

Just tidying up a couple of open questions. Formula worked well.

Thanks

Thanks

ASKER

Thanks

Ian