Untitled
unknown
plain_text
5 months ago
5.1 kB
2
Indexable
=IF(H11="app1", 0,
IF(H11="app2", INDIRECT("app1!AF251"),
IF(H11="app3", INDIRECT("app1!AF251") + INDIRECT("app2!AF251"),
IF(H11="app4", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251"),
IF(H11="app5", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251"),
IF(H11="app6", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251"),
IF(H11="app7", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251"),
IF(H11="app8", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251"),
IF(H11="app9", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251"),
IF(H11="app10", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251"),
IF(H11="app11", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251"),
IF(H11="app12", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251"),
IF(H11="app13", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251"),
IF(H11="app14", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251") + INDIRECT("app13!AF251"),
IF(H11="app15", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251") + INDIRECT("app13!AF251") + INDIRECT("app14!AF251"),
IF(H11="app16", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251") + INDIRECT("app13!AF251") + INDIRECT("app14!AF251") + INDIRECT("app15!AF251"),
IF(H11="app17", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251") + INDIRECT("app13!AF251") + INDIRECT("app14!AF251") + INDIRECT("app15!AF251") + INDIRECT("app16!AF251"),
IF(H11="app18", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251") + INDIRECT("app13!AF251") + INDIRECT("app14!AF251") + INDIRECT("app15!AF251") + INDIRECT("app16!AF251") + INDIRECT("app17!AF251"),
IF(H11="app19", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251") + INDIRECT("app13!AF251") + INDIRECT("app14!AF251") + INDIRECT("app15!AF251") + INDIRECT("app16!AF251") + INDIRECT("app17!AF251") + INDIRECT("app18!AF251"),
IF(H11="app20", INDIRECT("app1!AF251") + INDIRECT("app2!AF251") + INDIRECT("app3!AF251") + INDIRECT("app4!AF251") + INDIRECT("app5!AF251") + INDIRECT("app6!AF251") + INDIRECT("app7!AF251") + INDIRECT("app8!AF251") + INDIRECT("app9!AF251") + INDIRECT("app10!AF251") + INDIRECT("app11!AF251") + INDIRECT("app12!AF251") + INDIRECT("app13!AF251") + INDIRECT("app14!AF251") + INDIRECT("app15!AF251") + INDIRECT("app16!AF251") + INDIRECT("app17!AF251") + INDIRECT("app18!AF251") + INDIRECT("app19!AF251"),
0)))))))))))))))))))))Leave a Comment