creating formulas which ignore text in the relevant cells
 

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?

creating formulas which ignore text in the relevant cells
 

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




"help with excel formulas" wrote:

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?

creating formulas which ignore text in the relevant cells
 

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
--
TedMi


"help with excel formulas" wrote:

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?

creating formulas which ignore text in the relevant cells
 

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

Vaya con Dios,
Chuck, CABGx3


"tedmi" wrote:

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
--
TedMi


"help with excel formulas" wrote:

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?