Microsoft Office Forums - View Single Post - Display Difference Between Values In 2 Sheets

Thread: Display Difference Between Values In 2 Sheets

View Single Post

Old

07-04-2017, 12:56 PM

koltanga

koltanga is offline

koltanga uses Windows 10

Windows 10 koltanga uses Office 2007

koltanga uses Office 2007

Office 2007

Novice

The original poster

Join Date: May 2017

Posts: 4

koltanga is on a distinguished road

Default

Thanks NoSparks. Tweaked it a bit & now it is working. The working expression.

Code:

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

Reply With Quote