SumProduct

[stebrownsword]

Hi Guys

could someone please help with this formula, it states there's too many arguments


=SUMPRODUCT(--(SIP!AE:AE=WOD!$F$13),--(ISNUMBER(SEARCH("*Newly",SIP!K:K),SIP!U:U)


basically i want the formula to Sum Values in column U, if column AE equals the value of cell F13 and if the Column in K contains the text "Newly"


thanks in advance

 

[tyija1995]

Hi Guys

could someone please help with this formula, it states there's too many arguments


=SUMPRODUCT(--(SIP!AE:AE=WOD!$F$13),--(ISNUMBER(SEARCH("*Newly",SIP!K:K),SIP!U:U)


basically i want the formula to Sum Values in column U, if column AE equals the value of cell F13 and if the Column in K contains the text "Newly"


thanks in advance

Hey,

try:

EDIT: Apologies, saw you needed Newly to be contained:
=SUMPRODUCT((SIP!AE:AE=WOD!$F$13)*(ISNUMBER(SEARCH("Newly",SIP!K:K)))*(SIP!U:U))

 

[stebrownsword]

it comes back and states #value

 

[FormR]

Hi, why not use SUMIFS() - it's simpler and more efficient.

=SUMIFS(SIP!U:U,SIP!AE:AE,F13,SIP!K:K,"*newly*")

 

[stebrownsword]

it works a treat thank you so much