If in column R I have a 6 digit numeric string in each cell like below what would be the most efficient way to calculate the total of the first two digits, then the 2nd two, then the 3rd two, other than using a lengthy formulae for each cell like these
=LEFT(R1,1) + MID(R1,2,1)
=MID(R1,3,1) + MID(R1,4,1)
=MID(R1,5,1) + MID(R1,6,1)
I have experimented with =SUMIF() but maybe I didn't get the syntax right. Thanks.
110001
011101
000000
111111
101010
=LEFT(R1,1) + MID(R1,2,1)
=MID(R1,3,1) + MID(R1,4,1)
=MID(R1,5,1) + MID(R1,6,1)
I have experimented with =SUMIF() but maybe I didn't get the syntax right. Thanks.
110001
011101
000000
111111
101010