SumProduct

stebrownsword

Board Regular
Joined
Apr 16, 2010
Messages
151
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
766
Office Version
365
Platform
Windows
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))
 
Last edited:

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,405
Office Version
365
Platform
Windows
Hi, why not use SUMIFS() - it's simpler and more efficient.

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

Watch MrExcel Video

Forum statistics

Threads
1,098,858
Messages
5,465,106
Members
406,412
Latest member
superjoejoe

This Week's Hot Topics

Top