Fao: Excel Heads

[L]

Basically i've got a column where in each cell the value is between 0 and 3, I want to make it so that excel adds all the values together which is simple right..?The only thing is, i want it to count a 3 as 2 so that0 = 01 = 12 = 23 = 2How the f*ck do i do that?

[gemma]

i really tried but i cant work it out, the only thing i can think of is this=SUBSTITUTE(A4,"3","2", 1)if u have your column0123create another column next to it, but this column will substitute the number 3 with a 2, so u'll have this0 01 12 23 2then u can use the second column to do whatever and just hide it