Search:

Type: Posts; User: Tumble; Keyword(s):

Search: Search took 0.07 seconds.

  1. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    HAHAH.. no, really I know this one! That'll be your basic cell formatting - you need to change it to either "number" or "general"
  2. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    Thanks for all the help & suggestions :) I believe I have got it gripped now, and in the layout I've been using :) Can always count on Hexus for an assist!
  3. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    That's cool.... I have managed to do something, but I had to make a cell for every total, and add that column together, and then hide that column :p Your solution is a lot more elegant! Question...
  4. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    I've tried the SUMIF - I can't make it work though :( Clearly I'm doing it all wrong....
  5. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    That was just a rough thing I knocked up last night - I 'll do a screenshot of the actual table in a bit :)

    EDIT:

    Here's a bit of the actual sheet. The weeks are stacked on top of each other...
  6. Replies
    18
    Views
    1,455

    Calling all Excel wizards

    Morning folks,

    Got a bit of a problem with a spreadsheet I'm trying to build. I have to record mileage for work and I've got the thing set out so it calculates the total mileage each day if I put...
Results 1 to 6 of 6