I have this formula.
I have some places I add a second number to search for.
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
Code:
[COLOR=black][SIZE=3][FONT=Calibri]=SUM(SUMIF(Sheet1!P:P,{"640533*"},Sheet1!B:B))[/FONT][/SIZE][/COLOR]
[COLOR=black][/COLOR]
Code:
[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]
Code:
[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]