Thread: Display Difference Between Values In 2 Sheets
View Single Post
 
Old 07-02-2017, 01:40 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
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)
Reply With Quote