Excel Excel 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!

 

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

 

[Chuck D]

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