Return SUM If one column is populated and another column equals one of two criteria

[johnmitch38]

Afternoon all,

I've been trying to figure this out with SUMIF(S) and SUMPRODUCT but i can't figure it out.

On the attached, if B9 equals either "6th shift"(H3) or "6th shift (+10)"(X7) and O9 is greater than zero i.e. populated, then i want to return the figure in U9.

Ive tried things like =sum(sumifs(U9,OR(B9,H3,B9,X7)+sumif(U9,O9>0)) but it doesn't work.

Hopefully you can see what i'm getting at - please help!

[Fotis1991]

Hi

Forgot the attached!

[johnmitch38]

attachment now attached

[Melvinrobb]

You aren't looking for the sum, you simply want one value returned. The formula can be quite simple then. This should do the trick:

Please Login or Register  to view this content.

[johnmitch38]

Thanks mate - altered slightly from yours - =IF(AND(OR(B9=$H$3,B9=$X$7),O9<>""),U9,"")

You're right, i was trying to overcomplicate it.

Thanks again.