shantraj.antin@gmail.com Member Jun 28, 2018 #1 Hi Guys, I need to sum the data form all the 4 tables into 1 table with reference to Name. Attached is the sample file. Attachments Sample.xlsx 14.3 KB · Views: 10
Hi Guys, I need to sum the data form all the 4 tables into 1 table with reference to Name. Attached is the sample file.
Thangavel Active Member Jun 28, 2018 #2 You can try with sum(Index+match ) to get the total from another table. Check here for consolidating data in excel sheet: https://www.ablebits.com/office-addins-blog/2015/09/01/consolidate-excel-merge-sheets/ Last edited: Jun 28, 2018
You can try with sum(Index+match ) to get the total from another table. Check here for consolidating data in excel sheet: https://www.ablebits.com/office-addins-blog/2015/09/01/consolidate-excel-merge-sheets/
B bosco_yip Excel Ninja Jun 28, 2018 #4 Perhaps……. In C55, copied across and down : =SUMIF($B$5:$B$50,$B55,C$5:C$50)+SUMIF($L$5:$L$50,$B55,M$5:M$50) Regards Bosco
Perhaps……. In C55, copied across and down : =SUMIF($B$5:$B$50,$B55,C$5:C$50)+SUMIF($L$5:$L$50,$B55,M$5:M$50) Regards Bosco