Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2020, 03:02 AM
SoMany SoMany is offline If-then formula? Windows 7 64bit If-then formula? Office 2016
Advanced Beginner
If-then formula?
 
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default If-then formula?

Ok, I need help. I took two formulas and tried to combine them to make I sort of If-Then formula. If LEFT is true, then count the amount to the right. Please help!

=IF(([Orderfilling.xlsx]LEFT(Sheet1!K5:K50),"CP"=TRUE, SUM([Orderfilling.xlsx]Sheet1!L5:!L50))



Edit: Actually, this formula is probably close to what I'm trying to do, but still flawed;


=IF(ISNA([Orderfilling.xlsx]Sheet1!K5:K50,"CP"=TRUE, SUM([Orderfilling.xlsx]Sheet1!L5:!L50))
Reply With Quote
  #2  
Old 12-20-2020, 06:11 AM
Purfleet Purfleet is offline If-then formula? Windows 10 If-then formula? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

its so much easier to see what you are trying to do with a example workbook, please up load a proper example
Reply With Quote
  #3  
Old 12-20-2020, 09:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If-then formula? Windows 7 64bit If-then formula? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Your syntax is incorrect for the IF function and the LEFT function
Might I suggest you search for the correct syntax first?
Reply With Quote
  #4  
Old 12-21-2020, 08:49 AM
SoMany SoMany is offline If-then formula? Windows 7 64bit If-then formula? Office 2016
Advanced Beginner
If-then formula?
 
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default

Quote:
Originally Posted by Purfleet View Post
its so much easier to see what you are trying to do with a example workbook, please up load a proper example
How about this example? I want the Total sheet to give me the sum of every item with "Inventory" to the left of the cell listed in the Amount sheet.
Attached Files
File Type: xlsx Example.xlsx (9.9 KB, 6 views)
Reply With Quote
  #5  
Old 12-21-2020, 09:02 AM
SoMany SoMany is offline If-then formula? Windows 7 64bit If-then formula? Office 2016
Advanced Beginner
If-then formula?
 
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
  #6  
Old 12-21-2020, 09:13 AM
Purfleet Purfleet is offline If-then formula? Windows 10 If-then formula? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Good stuff
Reply With Quote
  #7  
Old 12-22-2020, 01:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If-then formula? Windows 7 64bit If-then formula? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Good show !
You could also have used the SUMPRODUCT function, which is more flexible but somewhat more complicated to use
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If or formula help zhead Excel 8 04-25-2018 07:09 AM
Formula Copy Row 2 Row But Next Column In Formula From Another Tab TimG Excel 3 04-16-2018 09:20 PM
IF Formula Paula Excel 2 09-21-2017 12:39 AM
If-then formula? Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft