Help With This Formula

[rockyw]

I have this formula.

[COLOR=black][SIZE=3][FONT=Calibri]=SUM(SUMIF(Sheet1!P:P,{"640533*"},Sheet1!B:B))[/FONT][/SIZE][/COLOR]
[COLOR=black][/COLOR]

I have some places I add a second number to search for.

[COLOR=black][SIZE=3][FONT=Calibri]=SUM(SUMIF(Sheet1!P:P,{"640533*","6502145*"},Sheet1!B:B))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT][/SIZE][/COLOR]

I also use this formula to only show results over a set value, but I can not add a second number to this ormula. Could someone tell me why? What can I change so I can add a second or 3rd number to this like the other formula. Thanks

[COLOR=black][SIZE=3][FONT=Calibri]=IF(SUMIF(Sheet1!P:P,"640533*",Sheet1!B:B)<250000, "", SUMIF(Sheet1!P:P,"640533*",Sheet1!B:B))<o:p></o:p>[/FONT][/SIZE][/COLOR]

 

[Marcelo Branco]

Hi,

I think this should work

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

M.

 

[rockyw]

Thank you I will give this a try. Have a great week.