Two formulas in one cell

  • Thread starter Thread starter something68
  • Start date Start date
S

something68

I wonder if it is possible to add another formula to the following:

=SUMIF(A1:A10,"H",B1:B10)

such as =SUMIF(A1:A10,"MO",B1:B10)

to show: H = 4 [hours] and MO = 2 [hours] in column V8
 
Try this (all on one line):

="H = "&SUMIF(A1:A10,"H",B1:B10)
&" and MO = "&SUMIF(A1:A10,"MO",B1:B10)
 
Back
Top