Display Difference Between Values In 2 Sheets

		Microsoft Office Forums > Microsoft Excel > Excel
Display Difference Between Values In 2 Sheets

07-02-2017, 01:40 PM

NoSparks

Windows 7 64bit Display Difference Between Values In 2 Sheets

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Try this in M4 of "Master List" and drag down

=$B4-SUMIF(Subset!$B$2:$B$660,'Master List'!$A4,Subset!$D$2:$D$660)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
get values from sheets	pero978	Excel	1	01-11-2016 11:37 PM
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM
Reporting Values Between Sheets/Tabs	jjbNana	Excel	3	10-06-2011 10:28 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 PM.