Excel Excel help - sumif function two conditions


Joined
Nov 20, 2009
Messages
1
Reaction score
0
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

Last edited:
Ad

Advertisements

Joined
Nov 23, 2007
Messages
28
Reaction score
2
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

Advertisements

Joined
Nov 23, 2007
Messages
28
Reaction score
2
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.

Ask a Question

Similar Threads


Top