How to Use SUMIF to only sum with a condition

[CasinoDavid]

So I have the formula =SUMIF(AO$8:AO$239,AL256,Y$8:Y$239)
But I only want to sum if the number is greater than zero.(in the Y col)
How do I do that?
Thanks

[jeffreybrown]

Is your version correct? Do you have 2007?

If 2007 =SUMPRODUCT(--($Y$8:$Y$239>0),--($AO$8:$AO$239=AL256),$Y$8:$Y$239)

If a version greater than 2007 =SUMIFS($Y$8:$Y$239,$Y$8:$Y$239,">0",$AO$8:$AO$239,AL256)