Will You Help Add SOmething To This Formula

[rockyw]

I have..

=SUM(SUMIF(Sheet1!P:P,{"640533*"},Sheet1!B:B))

Can I add something that will not return a value less than 250,000 or what even value I put in there? I tried several > 250,000 but I don't know exactly where to put that
Thnaks

 

[AlphaFrog]

Is this what you want?

=IF(SUMIF(Sheet1!P:P,"640533*",Sheet1!B:B)<250000, "", SUMIF(Sheet1!P:P,"640533*",Sheet1!B:B))

 

[rockyw]

YES YES that works, I love Excel but it,s hard to learn all the things to get a formula or code to work. Thank and have a great weekend.