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
Unique Value Count in 3 Columns Using Search Criteria 0
Using a SUMIF and Parsing to sum part of a cell 7
Cumulative formula for word table 0
macro for a range 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
MIN ingnoring zero sum in an range of cells 2
sumproduct across worksheets 4

Top