Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: I think the "IF" function

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    NYC
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I am trying to make a log book.
    I have two Qs.
    1st. In column G, I need to put from A-B (A&B being destinations and are always changing.) I need the - to indicate that the sum of columns I to R should be
    placed in column T.

    2nd. I need to have the sum of column X automatically placed into the beginning of a column X on the second, third page etc. of the same sheet.


    TVMIA

    Gord

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Gord,

    I am unclear about what your question is, so perhaps others are too. In your first question, do you mean that if the text in column G on any row contains a hyphen anywhere in it that the sum of columns I through R should be placed in column T of the same row?

    Regarding your second question, how do you define a page? Do you mean a printed page (which would change depending on how you define paper size, orientation, etc.)? Have you defined page breaks on certain rows? Do you have a page header for each page built in to your worksheet? Do you have a fixed number of rows per page? The questions here are really trying to determine how the code would know where the top of a page is to place the starting total.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This should be very easy to do, but you need to spell out the instrustions MUCH clearer.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •