Help Mr. Wizard

  1. okmatthew
    okmatthew
    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
  2. scottc_00
    scottc_00
    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.
Results 1 to 2 of 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1