sumif with multiple criteria

[B.Kellough]

I am trying to use a "sumif" formula with no luck. the formula looks like
=sumif(J:J,">0", I:I,A2)

Does anyone know how I can make this work?

 

[number kruncher]

Which Column do you need to sum?

What criteria do you need?

 

[B.Kellough]

I'm needing the the formula to verify if J:J says "Direct Handoff" then if it does it will SUM the values in column I:I.

 

[markmzz]

B.Kellough,

Try this formula:

=SUMPRODUCT(--(I:I=A2),--(J:J>0),(J:J))

Markmzz

 

[number kruncher]

Or try,

=sumif(J:J,"Direct Handoff",I:I)

 

[B.Kellough]

Thaks both worked with just a small twick; this is what I used;

=SUMIF(National!E:E,"U-Verse - Maintenance Direct",National!J:J)

 

[nkhan]

How can i search on 2 criteria and sum the column of values needed

eg
if a1 "PEtER" is matched in column a4-a25 = names
and b1 is matched in column b4-b25 = month
column c4-c25 = values required

 

[number kruncher]

If you have Excel 2007 onwards, then you can use SUMIFS, eg.

=SUMIFS(National!J:J,National!E:E,"U-Verse - Maintenance Direct",Column,Test)