Total of two figures in one cell

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

Luke M

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

something68

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

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?
 
S

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!
 
L

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?
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top