I was helped a few months ago by an expert. He provided me code that would calculate totals on a spreadsheet without any formulas needed. This works great as long as someone enters a value into a cell manually or copies and pastes a value into a cell, but if the cells are filled using the auto-fill drag method, the totals do not calculate. You will notice this in row 41 of the attached sheet. There is an entry of $25,000,00 in cell I41 that was manually typed, and the total below is working, but if you look to the right at cells K41 thru P41, which were populated with auto fill, the totals do not populate. If you type over any of those $25,000 entries, you will see the total populate. Can I make this work no matter how the user gets the value in the cell?