# ExcelExcel help - sumif function two conditions

#### DavidWeis

Hi - help really needed!

I am in excel trying to do a sumif function with two conditions.

I want a formula to calculate the number of instances where:
the business unit is 1 (columnB)
AND
the hours is not blank (columnG)

so in the example below the result would be 4 (relating to rows 2, 4, 12 and 13). I need both conditions to be met!

Please could someone more intelligent that me suggest a formula!

Many many many thanks!

#### Attachments

• 44.5 KB Views: 183
Last edited:
Ad

#### Chuck D

OK, Working with Excel at moment so your prob was a diversion...

Have got an answer bearing in mind I am no pro....

Add additional column at end of spreadsheet "Coll X" level with your example.doc line 2
insert the formula: =IF(AND(A2=1;F2>0);A2;0)
Now copy this down your column "X" to bottom of spreadsheet
We now have IF Business units =1 and IF Hours greater than 0, Business unit will be displayed in column "X" ie:1
At bottom of column or anywhere on your sheet Put =SUM(X2: X???) (end of lines to be calculated)
and you have the sum of all businessunits"1" which have more than "O" hrs labour logged...

Thanks again for the diversion and let me know how it fits your sheet

Chuck D.

Ad

#### Chuck D

It is not your SUMIF, but the SUM of IFAND, maybe somebodyelse can combine the two for you

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