What I want to do is use a formula to add all the values in cell A20 in all the workbooks ina given folder to each other and display the result in a seperate workbook. Is this possible? The value is a dollar amount, and I would like to have another work book that tracks the information in the other excel sheets. This added value would be like a year to date value. Can anyone help me with this?