Total of two figures in one cell
 

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

Total of two figures in one cell
 

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

Total of two figures in one cell
 

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

Total of two figures in one cell
 

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

"something68" wrote in message
...
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).

Total of two figures in one cell
 

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

Total of two figures in one cell
 

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


"Luke M" wrote:

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

Total of two figures in one cell
 

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

Total of two figures in one cell
 

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

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


"something68" wrote:

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

Total of two figures in one cell
 

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

"Luke M" wrote:

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

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


"something68" wrote:

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