Total of two figures in one cell

[something68]

Maybe I'm not explaining what I need very well so I'll try it this way since
I cannot attach an example of an excel sheet:

In column B, row 8 I have "H"...in column D, row 8 I have "AL"...in column
E, row 8 I have "H"
In column B, row 9 I have "8"...in column D, row 9 I have "8"...in column E,
row 9 I have "8"

I would like column U, row 8 to show "H, AL" and column U, row 9 to show
"16, 8" (H's on row 8 have been totaled to 16).

 

[Luke M]

Sounds like you're wanting something like this:
=SUMIF(B8:E8,"H",B9:E9)&", "&SUMIF(B8:E8,"AL",B9:E9)

 

[something68]

YES! So close, unfortunately, it shows "0, 0"...??? (I copied and pasted
your formula).

 

[David Biddulph]

=IF(AND(ISNUMBER(B8),ISNUMBER(H8)),B8+H8,B8)&", "&D8 and copy down

 

[Luke M]

The numbers that you have in row 9...are they actually numbers, or are they
text (check cell formatting)?

Less likely, but are there any spaces before/after the letters in row 8?

 

[something68]

Yes, they are actual numbers (I formatted to 2 decimal places).

 

[something68]

Thank you so much, I fixed the formula to work for me but I have another
dilemma if you could possibly help me again.

This time:

In column B, row 8 I have "S"...in column C, row 8 I have "SB"
In column B, row 9 I have "8"...in column C, row 9 I have "8"
I would like column R, row 8/9 to show "16" the total of S and SB...

Thank you so very much!

 

[Luke M]

Change the criteria matches in formula:

=SUMIF(B8:E8,"S",B9:E9)&", "&SUMIF(B8:E8,"SB",B9:E9)

Just curious, what did you have to change to the formula to make it work?

 

[something68]

=SUMIF(B11:O11,"H",B12:O12)&", "&SUMIF(B11:O11,"AL",B12:O12)&",
"&SUMIF(B11:O11,"MO",B12:O12). I think I had to remember to change the range
of cells from "E11" to "O11" - sorry, my fault.

Also, I think I tried your suggestion below. This total, I do not want to
show "8, 8". I would like to show the total of two different columns ("S" in
one column and "SB" in another) in row 9 ("16" in the last column - no commas
or spaces). Make sense? Sorry if I've confused you.

I so very much appreciate your help. I knew there was a way to do such
functions, I just don't know how to figure out formulas.