Search:

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

Search: Search took 0.06 seconds.

  1. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    because it thinks you're a prune?
  2. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    $ fix a range as an absolute reference, so it doesn't change as you drag to copy formula into other cells. It fixes the part of the reference following it.

    eg set up a simple sheet
    numbers 1-5...
  3. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    sorry, I don't have a lot of time atm, but as a stop gap just use a standard if function if(B3="private",,A3*whatever you want to do with it) to populate a column from which you can use a simple...
  4. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    sumif was around in office 2000, I think it was there in 97 too.
  5. Replies
    18
    Views
    1,455

    Re: Calling all Excel wizards

    sumif (or even just a standard if routine) is the way to go. Vlookup is a different beast.
Results 1 to 5 of 5