Sum of Row with Letters and Merged Numbers in Different Cells

[Apples52]

Hi all, is there a formula I can use to sum a portion of a row where one cell contains a letter, some cells are blank and the numerical cell is merged? In the screenshot attached, I've used a simple concotenate formula, but the layout of the report has now changed where it's not working and returning a "#value" error.

In the screenshot, I want to sum I:M. You can't see this, but cell I272 has the letter "A" in it if you click on the cell. J272, L272 and M272 are blank and K272 with the numerical value is merged with K273.

I've tried unmerging column K, but am still getting that #value error when using concoctenate or sum. I'm assuming it has to do with the letter "A" being in cell I272. Is there a formula that will work with the data as is? I'd like to avoid the extra steps of deleting text and unmerging in those total rows.

Thanks in advance

 

[Joe4]

Using "+" on cells with text results in errors. But using the SUM function will ignore all text values.
So try:

=SUM(I272:M272)

I am not sure why you would ever try to use Concatenate. That is just used to combined smaller string into one large string. It will never add/sum values.

 

[Apples52]

Using "+" on cells with text results in errors. But using the SUM function will ignore all text values.
So try:

=SUM(I272:M272)

I am not sure why you would ever try to use Concatenate. That is just used to combined smaller string into one large string. It will never add/sum values.

I feel a tad embarrassed, this was far too easy. I swear I tried a simple sum before and it didn't work. But I must not have because I just did and it works perfectly.

Thank you!

 

[Joe4]

You are welcome!

No worries, it happens to all of us at one time or another!