Add cells with letter & numbers in the cell

[Will2839]

Hello I'am trying to add a row of cell that contain a letter befor the number
I need to add-up the numbers and ignore the letter

Thanks for your help in advance
Will

[dominicb]

Good afternoon Will2839

...and welcome to the forum!!

Could you provide an example of what type of information is contained in these cells. What's the format of the cells, always the same letter, ever any more than one letter etc?

DominicB

[darkyam]

If it is always just one letter, try

Please Login or Register  to view this content.

confirmed with Ctrl+Shift+Enter.

[Will2839]

In the row of cells,Sometimes there will be an R in the cell with a number.
Always a R and It could be before or after the number it would not matter
I would need to add these cells that have an R in them.and add the number part of the cell

[darkyam]

OK, try

Please Login or Register  to view this content.

confirmed with Ctrl+Shift+Enter

[Will2839]

Sorry DARKYAM . That one did not work
Would you have something else

[darkyam]

It works for me when I try it. Did you hit Ctrl+Shift+Enter after you entered the formula or just Enter? Also, if these "R"s can be either uppercase or lowercase, the formula would have to be adjusted to

Please Login or Register  to view this content.

confirmed with Ctrl+Shift+Enter.
If neither of these is the issue, could you please post a sample workbook with the results or tell us what is happening when you try the formula?

[Will2839]

Sorry DARKYAM .
That one did not work
Would you have something else

[Will2839]

just enter,i'll try it again

[Will2839]

Sorry Darkyam,
It come up with a value error

[darkyam]

Can you please post a sample of the data you're working with that shows this error?

[Will2839]

=SUM(SUBSTITUTE(AF11,"R"," ")+0)
This works on 1 cell i cant get it to work on a row E6:AI6

Any thoughts

[darkyam]

Without seeing a workbook, it is hard to pinpoint the issue. I would replace the " " with "", but if it is working for one cell, then it doesn't appear to be the problem. Does your formula have curly brackets {} around it? These come when you confirm the formula with Ctrl+Shift+Enter but disappear any time you try to edit the formula. If they are not there, please add them by confirming the formula again. If this does not solve your issue, posting the workbook is the best way to get this solved.

[bautista]

What would the formula be with any letter? I used both of the samples above for my document and it worked. But I frequently have values that consist of numbers with different letters.

Thanks.

[arlu1201]

bautista,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[bautista]

Sorry...thought it made more sense to continue the same line of questioning rather than start a new one.

Thanks.