We have two different workbooks (Master & Slave) both the workbooks have one unique column i.e ID. Slave workbook has duplicates ID along with Amount figure. We want to get the sum total of those duplicates ID's amount and single entry amount should also be reflected on our Master workbook amount column.
eg
Slave Workbook
ID Amount
766 800
566 900
766 1000
675 200
566 100
Master Workbook
ID Amount
766
566
675
G'day and welcome to the forum,
Use the SUMIF formula
Eg
'MasterWorkbook'!A1 = 766
Please Login or Register to view this content.
Last edited by ratcat; 04-06-2013 at 10:53 PM. Reason: Wrap code around the formula
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
Oh! it actually worked. Thank u so much ratcat.
Actually the formula you gave works in worksheets but not in workbook which i realized later. Please provide me with workbook formula...... and if we try to put the formula in workbook it every time for each row it asks to select the workbook ie master & slave
Try with SUMPRODUCT, that works with closed workbooks..
=SUMPRODUCT('SlaveWorkbook'!$A$1:$A$200='MasterWorkbook'!A1)*('SlaveWorkbook'!$B$1:$B$200))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks