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?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"something68" wrote:

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

"Luke M" wrote:

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"something68" wrote:

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).