Total of two figures in one cell

  • Thread starter Thread starter something68
  • Start date Start date
S

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).
 
Sounds like you're wanting something like this:
=SUMIF(B8:E8,"H",B9:E9)&", "&SUMIF(B8:E8,"AL",B9:E9)
 
YES! So close, unfortunately, it shows "0, 0"...??? (I copied and pasted
your formula).
 
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?
 
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!
 
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?
 
=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.
 
Back
Top