Two formulas in one cell

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
 
T

T. Valko

Try this (all on one line):

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

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

Similar Threads

Two formulas in one cell 3
Using a SUMIF and Parsing to sum part of a cell 6
SUMIF for date 2
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range. 10
MIN ingnoring zero sum in an range of cells 2
sumproduct across worksheets 4
Input Boxes 4 Inserting A Range In A Formula 5
Alpha sorting (with a twist...?) 3

Top