Thread: [Solved] If-then formula?
View Single Post
 
Old 12-21-2020, 09:02 AM
SoMany SoMany is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Your syntax is incorrect for the IF function and the LEFT function
Might I suggest you search for the correct syntax first?

I got it now. It was a SUMIF formula. Thank you.

=SUMIF(Amount!B2:B50,"*"&"Inventory"&"*", Amount!C2:C50)


Edit; for those interested in the correct formula for the original post, it was =SUMIF([Orderfilling.xlsx]Orderfilling!$K$5:$K$50, "CP", [Orderfilling.xlsx]Orderfilling!$L$5:$L$43)
Reply With Quote