Subtract value if cell contains X term

		Microsoft Office Forums > Microsoft Excel > Excel
Subtract value if cell contains X term

10-31-2016, 10:30 PM

xor

Windows 10 Subtract value if cell contains X term

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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)

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
How to Subtract value in table, based on two different conditions	nitemath2	Excel	1	06-19-2015 01:28 AM
Find what box in Find and replace limits the length of a search term	Hoxton118	Word VBA	7	06-10-2014 05:05 AM
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 07:24 PM.