Hi I created an ErlangC formula for my excel: {=IFERROR(SUM(IF(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1>=H2,0,IFERROR((((F2^ROW(INDIRECT("1:"&CEILING(H2+1,1))))/FACT(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1))*((H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))+1)/(F2+(H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))))),0))),0)} at the end, I want to use Array formula to sum it up, but it won't work. can you teach me why it won't do it? Thanks, Day Date Interval Forecast Schedule Calls Per Hr AHT Fcst Vol Target Ans (sec) ErlangC Sun 4/2/2023 8:00:00 AM 9 15 20 329 10 30 {=IFERROR(SUM(IF(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1>=H2,0,IFERROR((((F2^ROW(INDIRECT("1:"&CEILING(H2+1,1))))/FACT(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1))*((H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))+1)/(F2+(H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))))),0))),0)}

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Array formula doesn't work with ErlangC formula

Thread starter uwmarkyo
Start date Apr 3, 2023
Tags

array formula

uwmarkyo

New Member

Apr 3, 2023

Hi I created an ErlangC formula for my excel:

{=IFERROR(SUM(IF(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1>=H2,0,IFERROR((((F2^ROW(INDIRECT("1:"&CEILING(H2+1,1))))/FACT(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1))*((H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))+1)/(F2+(H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))))),0))),0)}

at the end, I want to use Array formula to sum it up, but it won't work. can you teach me why it won't do it?
Thanks,

Day	Date	Interval	Forecast	Schedule	Calls Per Hr	AHT	Fcst Vol	Target Ans (sec)	ErlangC
Sun	4/2/2023	8:00:00 AM	9	15	20	329	10	30	{=IFERROR(SUM(IF(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1>=H2,0,IFERROR((((F2^ROW(INDIRECT("1:"&CEILING(H2+1,1))))/FACT(ROW(INDIRECT("1:"&CEILING(H2+1,1)))-1))*((H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))+1)/(F2+(H2-ROW(INDIRECT("1:"&CEILING(H2+1,1)))))),0))),0)}