All 3

[Bigbroben]

I did 3 columns, one for each EC, if the new spin doesn't match previous then - 1 otherwise +1
Bank column adds all 3 up with an "if result is 0 then -3" ignoring the ec results

Ok,
what is appearing in the 3 columns when a zero hits?  What is the next spin comparing with? Zero's line or the other before?

[Sparks]

good point, hadn't thought of that, going to have to put in an if function for the EC formulas to calculate based on the result before the 0, otherwise it's looking at the 0 as the previous spin....

[Bigbroben]

You might hate me...

[Sparks]

there you go

[Bigbroben]

Yup.

Or even, on B,C,or D: IF($A5=0,B4,LOOKUP(...  so it keeps the same config as previous spin.