Thanks guys. I unintentionally omitted the "=" sign in front of my formulas when composing my post (it is, however, in my worksheet formulas). Jbeaucaire is correct, it should work as stated =(1+1+1)+(2+2+2). Mine is not working - I thought it might be an anomoly to Excel2007, but if it's working for some of you, it should work for me.

Back to the drawing board. I'll contact our IT people. Thanks again.