Vlookup and sumif
Posted on 2011-09-15
I have two workbooks.
Workbook One is called Summary and is located at C:\Month. I have a tab labeled MS Aug. In MS Aug column A represents the account number. An example of an account number would be 4025RM28 (there are many more account numbers beginning with 4025.) In the same tab column G represents a balance in for each different 4025 account.
Workbook Two is called CD Spreadsheets. In CD Spreadsheets I have a tab labeled #20. In cell L5 I need to sum all the values from the Summary workbook, where the first four digits are “4025” from the Summary workbook from A3:A640 and place that sum in L5 in the tab labeled #20.
In other words, in the CD Spreadsheets at L5 go to the Summary workbook, tab MS Aug and add all the values in column G where the first four digits in column A = 4025 in the Summary workbook tab MS Aug.