+ Reply to Thread
Results 1 to 6 of 6

Filling Down Formula

  1. #1
    Glenn
    Guest

    Filling Down Formula

    Is there a way to fill a column down which contains a calculation without
    having the result appear until the actual data is inputted?

    For a simple example: Column C is a running total of A and B, with C’s
    formula filled down to Row 5. I don’t want to have the running total appear
    in Column C for rows that haven’t any data entered. As shown below, I don’t
    want the last three 6’s appearing. The formula, beginning at C2 is:
    C2 =SUM(A2:B2)+C1
    C3 =SUM(A3:B3)+C2
    etc.

    Thank you for your assistance.

    A B C
    1 2 3
    1 2 6
    6
    6
    6


  2. #2
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106
    Can you let me know if this works for you?

    c2:
    =IF(AND(ISNUMBER(A2),ISNUMBER(B2)),SUM(A2:B2)+C1,"")

    copy down.


    Quote Originally Posted by Glenn
    Is there a way to fill a column down which contains a calculation without
    having the result appear until the actual data is inputted?

    For a simple example: Column C is a running total of A and B, with C’s
    formula filled down to Row 5. I don’t want to have the running total appear
    in Column C for rows that haven’t any data entered. As shown below, I don’t
    want the last three 6’s appearing. The formula, beginning at C2 is:
    C2 =SUM(A2:B2)+C1
    C3 =SUM(A3:B3)+C2
    etc.

    Thank you for your assistance.

    A B C
    1 2 3
    1 2 6
    6
    6
    6

  3. #3
    Dave Peterson
    Guest

    Re: Filling Down Formula

    Change your formula slightly to hide the sum:

    =if(count(a2:b2)=0,"",sum(a2:b2)+c1)



    Glenn wrote:
    >
    > Is there a way to fill a column down which contains a calculation without
    > having the result appear until the actual data is inputted?
    >
    > For a simple example: Column C is a running total of A and B, with C’s
    > formula filled down to Row 5. I don’t want to have the running total appear
    > in Column C for rows that haven’t any data entered. As shown below, I don’t
    > want the last three 6’s appearing. The formula, beginning at C2 is:
    > C2 =SUM(A2:B2)+C1
    > C3 =SUM(A3:B3)+C2
    > etc.
    >
    > Thank you for your assistance.
    >
    > A B C
    > 1 2 3
    > 1 2 6
    > 6
    > 6
    > 6


    --

    Dave Peterson

  4. #4
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106
    Dave's is better; less typing.
    Dave..you should register: you have good contributions.

  5. #5
    Glenn
    Guest

    Re: Filling Down Formula

    Wow! That's great Dave. Thanks. Couldn't have done it without you.

    "Dave Peterson" wrote:

    > Change your formula slightly to hide the sum:
    >
    > =if(count(a2:b2)=0,"",sum(a2:b2)+c1)
    >
    >
    >
    > Glenn wrote:
    > >
    > > Is there a way to fill a column down which contains a calculation without
    > > having the result appear until the actual data is inputted?
    > >
    > > For a simple example: Column C is a running total of A and B, with C’s
    > > formula filled down to Row 5. I don’t want to have the running total appear
    > > in Column C for rows that haven’t any data entered. As shown below, I don’t
    > > want the last three 6’s appearing. The formula, beginning at C2 is:
    > > C2 =SUM(A2:B2)+C1
    > > C3 =SUM(A3:B3)+C2
    > > etc.
    > >
    > > Thank you for your assistance.
    > >
    > > A B C
    > > 1 2 3
    > > 1 2 6
    > > 6
    > > 6
    > > 6

    >
    > --
    >
    > Dave Peterson
    >


  6. #6
    David McRitchie
    Guest

    Re: Filling Down Formula

    if a & b are empty on a row but you contiue with data in the
    next row, your running balance or whatever you have will
    start over.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Glenn" <Glenn@discussions.microsoft.com> wrote in message news:D6E3DA01-D7E2-43CA-A5E7-B444B180038F@microsoft.com...
    > Wow! That's great Dave. Thanks. Couldn't have done it without you.
    >
    > "Dave Peterson" wrote:
    >
    > > Change your formula slightly to hide the sum:
    > >
    > > =if(count(a2:b2)=0,"",sum(a2:b2)+c1)




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1