Two formulas in one cell

S

something68

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
 
S

something68

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
 
L

Luke M

Perhaps

=TEXT(SUMIF(B8:O8,"H"),"0.00")&", "&TEXT(SUMIF(B8:O8,"V"),"0.00")

is what you're looking for then.
 
S

something68

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

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