Getting "Formula Parse Error" after inputting this. Not sure if I'm missing a comma or parenthesis. I think I I'm following the rules for the IFS(), the AND() and the COUNTIFS(). Also not sure if there is a simpler way of writing this formula or if its best to use Google Apps Script.

I notice that this formula only works if I have 1 pair of arguments for IFS() (so that would be the first AND() and the first COUNTIFS(), but when I try to add another pair of arguments, then I get the formula parse error.

I had no problems putting COUNTIFS() inside an IF(), but due to the limitations with IF(), I had to give IFS() a try so that I can address more specific combinations of conditions.

IFS
(
AND($S$1 = "Include Both", $V$1 = "Any", $S$2 = "All"), 

    COUNTIFS
    ( 
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2
    ),

AND($S$1 = "Include Both", $V$1 != "Any", $S$2 = "All"),

    COUNTIFS
    (
        INDIRECT("'Activity Log'!$O$3:$O"), "="&$V$1, 
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1 ,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2
    ),

AND($S$1 = "Include Both", $V$1 = "Any", $S$2 != "All"),

    COUNTIFS
    (
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1 ,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2,  
        INDIRECT("'Activity Log'!$H$3:$H"), "="&$S$2
    ),

AND($S$1 = "Include Both", $V$1 != "Any", $S$2 != "All"),

    COUNTIFS
    (
    
        INDIRECT("'Activity Log'!$O$3:$O"), "="&$V$1, 
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2,  
        INDIRECT("'Activity Log'!$H$3:$H"), "="&$S$2
        
    ),

AND($S$1 != "Include Both", $V$1 = "Any", $S$2 = "All"),

    COUNTIFS
    (
    
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2, 
        INDIRECT("'Activity Log'!$M$3:$M"), "="&$S$1 
    ),

AND($S$1 != "Include Both", $V$1 != "Any", $S$2 = "All"),

    COUNTIFS
    (
    
        INDIRECT("'Activity Log'!$O$3:$O"), "="&$V$1, 
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2, 
        INDIRECT("'Activity Log'!$M$3:$M"), "="&$S$1 
        
        
    ),

AND($S$1 != "Include Both", $V$1 != "Any", $S$2 != "All"),

    COUNTIFS
    (
        INDIRECT("'Activity Log'!$O$3:$O"), "="&$V$1, 
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2, 
        INDIRECT("'Activity Log'!$M$3:$M"), "="&$S$1, 
        INDIRECT("'Activity Log'!$H$3:$H"), "="&$S$2
    ),

AND($S$1 != "Include Both", $V$1 = "Any", $S$2 != "All"),

    COUNTIFS
    (
        INDIRECT("'Activity Log'!$A$3:$A"), $N6, 
        INDIRECT("'Activity Log'!$E$3:$E"), "="&U$3,
        INDIRECT("'Activity Log'!$I$3:$I"), ">="&$N$1,
        INDIRECT("'Activity Log'!$I$3:$I"), "<="&$N$2, 
        INDIRECT("'Activity Log'!$M$3:$M"), "="&$S$1, 
        INDIRECT("'Activity Log'!$H$3:$H"), "="&$S$2
    )
)