Add sheet reference in CELL() content

[sassaboss]

Hello, I've been trying to insert a Sheet reference inside CELL() formula because I want to reffer to another Sheet, not in current Sheet, where I write given formula.
Cell reference that is bold AH$1 and AH$19000 should refer to Sheet named "AAA". Right now I am getting #REF in every case I've tried.
I tried to use INDIRECT but didn't have much luck.


Any help is more than welcome

=SUMIFS(
INDIRECT("FAKT_"&D$1&"!"&CELL("address";AH$1)&":"&CELL("address";AH$19000));
INDIRECT("FAKT_"&D$1&"!$S1:$S19000");$B12;
INDIRECT("FAKT_"&D$1&"!$C1:$C19000");$A$7
)

 

[sassaboss]

Best guess, it looks like this is what you need. The CELL function appears to be irrelevant.

=SUMIFS(
INDIRECT("FAKT_"&D$1&"AH$1:AH$19000);
INDIRECT("FAKT_"&D$1&"!$S1:$S19000");$B12&"*";
INDIRECT("FAKT_"&D$1&"!$C1:$C19000");$A$6
)

It works !!!
Thanks very much !