I tried to calculate "TRUE" and "FALSE" in Calculation sheet, but I'm getting the error "Array arguments to COUNTIFS are of different size". Any idea what I'm doing wrong?
Formula I'm using: =COUNTIFS(Data!A3:A,"0*",Data!B3:B,"Anna",Data!C3:C,B3,Data!D3:I,"TRUE")