Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2016, 10:54 AM
Jue92 Jue92 is offline Subtract value if cell contains X term Windows 8 Subtract value if cell contains X term Office 2013
Novice
Subtract value if cell contains X term
 
Join Date: Oct 2016
Posts: 4
Jue92 is on a distinguished road
Default Subtract value if cell contains X term

Hi,

I seem to be having difficulties with a very simple formula!

ITEM A


Cost A = B6
Outstanding Balance = C6

ITEM B
Cost A = B7
Outstanding Balance = C7

So, if a payment was entered as below:

(A) (B) (C) (D)
Date Paid Amount Method
19/10/2016 ITEM A £350.00 Cash
19/10/2016 ITEM A £300.00 Card
28/10/2016 ITEM B £50.00 BACS

I thought it would be something like =IF(B13:B100="ITEM A",B6-C13:C100,"")

Any help is appreciated!
Reply With Quote
  #2  
Old 10-31-2016, 06:16 AM
gebobs gebobs is offline Subtract value if cell contains X term Windows 7 64bit Subtract value if cell contains X term Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

It's hart to tell from your post what you are trying to accomplish. Please attach youor sheet.
Reply With Quote
  #3  
Old 10-31-2016, 06:28 AM
Jue92 Jue92 is offline Subtract value if cell contains X term Windows 8 Subtract value if cell contains X term Office 2013
Novice
Subtract value if cell contains X term
 
Join Date: Oct 2016
Posts: 4
Jue92 is on a distinguished road
Default

Hi gebobs, attached as requested.
Attached Images
File Type: png payment.png (15.7 KB, 14 views)
Reply With Quote
  #4  
Old 10-31-2016, 10:30 PM
xor xor is offline Subtract value if cell contains X term Windows 10 Subtract value if cell contains X term Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

You wrote:

I thought it would be something like =IF(B13:B100="ITEM A",B6-C13:C100,"")

What about: =$B$6-SUMIF($B$13:$B$100,"ITEM A",$C$13:$C$100)
Reply With Quote
  #5  
Old 11-01-2016, 01:45 AM
Jue92 Jue92 is offline Subtract value if cell contains X term Windows 8 Subtract value if cell contains X term Office 2013
Novice
Subtract value if cell contains X term
 
Join Date: Oct 2016
Posts: 4
Jue92 is on a distinguished road
Default

That worked. Thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtract value from one cell into another otuatail Excel 3 02-01-2016 03:21 AM
Use a numerical merge field to subtract that number of months MichaelSpedding Mail Merge 8 11-11-2015 01:11 PM
Subtract value if cell contains X term How to Subtract value in table, based on two different conditions nitemath2 Excel 1 06-19-2015 01:28 AM
Subtract value if cell contains X term Find what box in Find and replace limits the length of a search term Hoxton118 Word VBA 7 06-10-2014 05:05 AM
Subtract value if cell contains X term Insert input box into macro to allow user to define search term Hoxton118 Word VBA 3 05-19-2014 02:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 PM.


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