Hello everyone,
Got a question regarding this formula:
={SUM(IFERROR(INDEX(1!$A:$P;(MATCH(Quart;1!$C:$C;0)+MATCH($B$1;1!$L$6:$L$20;0));MATCH(INDEX(2!$B:$B;MATCH($D4;2!$C:$C;0));1!$6:$6;0)+1);0))}
It seems to work just fine when I array it via 2 cells it works just fine, but if I try to array it in a single cell it only picks up the first value from the "Quart" formula I am using, maybe someone has a trick how to bypass the need to apply the formula via 2 cells and make it work in a single one?
Bookmarks