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