Sum Cells from Different Workbooks into another Workbook Based on Another Cell

[DTMAVEN]

Hello,

I would like to sum Column M "Amount" of two separate workbooks and add them to Column E "Amount Spent" in another workbook based on Column A "Budget #" of all 3 workbooks.

I have attached the two separate workbooks, "test budget tracker rq" and "test budget tracker sub," and before and after spreadsheets where I would like the sums to appear in "TEST - Budget Appropriations for help."

Could this also be done automatically so that as lines are entered, they will automatically be added to the "TEST - Budget Appropriations" spreadsheet?

I'm not sure if this makes a difference but both "test budget tracker" spreadsheets can be as large as 3000 rows and the "TEST - Budget Appropriations" spreadsheet will have about 200 rows.

Also, do these all three workbooks need to be in the same folder?

Thanks in advance!

[AliGW]

Are you really still using Excel 2010?

Did you know that there’s a thread of yours from 2018 where you received substantial help that went unacknowledged? Did you forget about it?

[DTMAVEN]

I am using Excel 2016.

Thank you. I just acknowledged the other thread. I am not versed enough in VBA to follow so was hoping this thread with formulas would help me at the level that I am at in Excel.

[AliGW]

Please update your forum profile with the correct version of Excel.

Strictly speaking this is a duplicate thread, but because of the time that has elapsed I am prepared to let it stand on this occasion.

I will close the other thread and divert traffic here.