Sorry if multiple postings are frowned upon. As Sargent Shultz Said, "I Know Nothing!" I've got a spread sheet someone set up for me to keep track of my American Red Cross Mileage and Expenses. That person is no longer available to help me. I've added a column to keep track of my actual fuel cost BUT it is being added to the grand total. What I am hoping to find is some Excel Wizard to take my spread sheet and fix it so my actual Fuel Expense column adds up separately and doesn't get added to the Grand total. Thanks, 777atthew
If the original formula was Sum(A1:D1) for example and you added a column beofre column D, your formula would change to Sum(A1:E1), which would include the column you added. You need to adjust your formula to Sum(A1:C1,E1) same as A1+B1+C1+E1. Which will add up all the column you want and omit the column you dont want.