creating formulas which ignore text in the relevant cells

[help with excel formulas]

How can you create a formula which will ignore text in the cells the formula
is relevant to?

i.e i have a row of numbers which SUM will add up as a formula, however
sometimes i need to have a number plus a letter in the same cell as soon as i
do this the formula ignores the number and creates an error

Any help?

 

[CLR]

Depending on exactly how your TEXT string is constructed, something like this
should work..........

=(LEFT(A1,LEN(A1)-1)*1)+3

Vaya con Dios,
Chuck, CABGx3

 

[tedmi]

The easiest way to do this is to spread your data over three columns, like so:
Col.A contains just numbers
Col.B contains just the text that may get combined with numbers
Col.C contains the formulas A1&B1, copied down
Run your sum on Col.A
For reporting purposes, you can hide Cols A and B, and put the Sum(A1.Axx)
function at the foot of Col.C

 

[CLR]

Good answer, TedMi.........I misread the OP's post

Vaya con Dios,
Chuck, CABGx3