| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert total amount figures in excel to the next colum | Excel Discussion (Misc queries) | |||
| building YTD figures by adding to a previous months total | Excel Discussion (Misc queries) | |||
| how do i set uo total income and annual figures in excel? | New Users to Excel | |||
| Sum total bolded figures in a column | Excel Discussion (Misc queries) | |||
| ADDITIONAL FIGURES IN COLUMN DON'T ADD TO TOTAL IN EXCEL | Excel Worksheet Functions | |||
Linear Mode
