how to sum logical array?
if I use `=SUM(TRUE,FALSE,TRUE)`

it give 2

Now, Let the cell A1 is abcdea & I used `=IFERROR(MID(A1,ROW(A1:A11),1)=MID(A1,LEN(A1)+1-ROW(A1:A11),1),0)`

and then checked by F9 it gives {TRUE;FALSE;FALSE;FALSE;FALSE;TRUE;0;0;0;0;0}
now if I use `=SUM(IFERROR(MID(A1,ROW(A1:A11),1)=MID(A1,LEN(A1)+1-ROW(A1:A11),1),0))`

it gives zero , but I expected 2.
so is there any way to SUM logical arrays?
Thanks!
regards,