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
|