| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two formulas in one cell
Unfortunately, the previous formula was not helpful.
I am trying to make cell V7 show both H and MO... Cell A5 shows "H" 3, A6 shows "H" 1 , and Cell A7 shows "MO" 1 and Cell A8 shows "MO" 1. Would I be able to show both H and MO in cell V7 and the totals in cell V8? My current formula is: =SUMIF(B8:O8,"H",B9:O9). Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two formulas in one cell
What are you wanting the results to look like, as a I believe the previous
formula should have worked. ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) If you need them on two lines, make sure your cell is tall enough and activate word wrap, and change formula to: ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&CHAR(10)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "something68" wrote: Unfortunately, the previous formula was not helpful. I am trying to make cell V7 show both H and MO... Cell A5 shows "H" 3, A6 shows "H" 1 , and Cell A7 shows "MO" 1 and Cell A8 shows "MO" 1. Would I be able to show both H and MO in cell V7 and the totals in cell V8? My current formula is: =SUMIF(B8:O8,"H",B9:O9). Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two formulas in one cell
Sorry, this did not help, as I need the hours to show "0.00" and "separate"
in the same cell: H, MO 5.00, 2.00 changing height of rows would not be a good idea as I am trying to keep it to one page for quick reference. Thanks "Luke M" wrote: What are you wanting the results to look like, as a I believe the previous formula should have worked. ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) If you need them on two lines, make sure your cell is tall enough and activate word wrap, and change formula to: ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&CHAR(10)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "something68" wrote: Unfortunately, the previous formula was not helpful. I am trying to make cell V7 show both H and MO... Cell A5 shows "H" 3, A6 shows "H" 1 , and Cell A7 shows "MO" 1 and Cell A8 shows "MO" 1. Would I be able to show both H and MO in cell V7 and the totals in cell V8? My current formula is: =SUMIF(B8:O8,"H",B9:O9). Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two formulas in one cell
Perhaps
=TEXT(SUMIF(B8:O8,"H"),"0.00")&", "&TEXT(SUMIF(B8:O8,"V"),"0.00") is what you're looking for then. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "something68" wrote: Sorry, this did not help, as I need the hours to show "0.00" and "separate" in the same cell: H, MO 5.00, 2.00 changing height of rows would not be a good idea as I am trying to keep it to one page for quick reference. Thanks "Luke M" wrote: What are you wanting the results to look like, as a I believe the previous formula should have worked. ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) If you need them on two lines, make sure your cell is tall enough and activate word wrap, and change formula to: ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&CHAR(10)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "something68" wrote: Unfortunately, the previous formula was not helpful. I am trying to make cell V7 show both H and MO... Cell A5 shows "H" 3, A6 shows "H" 1 , and Cell A7 shows "MO" 1 and Cell A8 shows "MO" 1. Would I be able to show both H and MO in cell V7 and the totals in cell V8? My current formula is: =SUMIF(B8:O8,"H",B9:O9). Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two formulas in one cell
Ah! So very close. With this formula, it shows "0.00, 0.00" on one cell but
does not show the total of information I enter, i.e. 2.00, 3.00... "Luke M" wrote: Perhaps =TEXT(SUMIF(B8:O8,"H"),"0.00")&", "&TEXT(SUMIF(B8:O8,"V"),"0.00") is what you're looking for then. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "something68" wrote: Sorry, this did not help, as I need the hours to show "0.00" and "separate" in the same cell: H, MO 5.00, 2.00 changing height of rows would not be a good idea as I am trying to keep it to one page for quick reference. Thanks "Luke M" wrote: What are you wanting the results to look like, as a I believe the previous formula should have worked. ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) If you need them on two lines, make sure your cell is tall enough and activate word wrap, and change formula to: ="H total is: "&SUMIF(B8:O8,"H",B9:O9)&CHAR(10)&"V total is: "&SUMIF(B8:O8,"V",B9:O9) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "something68" wrote: Unfortunately, the previous formula was not helpful. I am trying to make cell V7 show both H and MO... Cell A5 shows "H" 3, A6 shows "H" 1 , and Cell A7 shows "MO" 1 and Cell A8 shows "MO" 1. Would I be able to show both H and MO in cell V7 and the totals in cell V8? My current formula is: =SUMIF(B8:O8,"H",B9:O9). Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
| CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
| How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
| Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
| change cell value greater than another cell value using formulas | Excel Worksheet Functions | |||
Linear Mode
