Results 1 to 5 of 5

Thread: SUM formula on Dynamic columns

  1. #1

    SUM formula on Dynamic columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Everyone,

    I need to write a SUM formula for Dynamic column called Total.

    Initially the formula will be in Z1 (=SUM(A1:Y1))
    Next time it can be D1 = SUM(A1:C1)

    So every time the calculated columns may change and calculated cell column will also be changed.

    Please help.

  2. #2
    Try

    D1: = SUM($A$1:C$1)

  3. #3
    It is not always D1 , See if i have 4 columns exist then my formula should be in 5 th column then formula should be E1 = A11, so that time the above formula is incorrect. It has to be dynamic by displayed columns.

  4. #4
    Good afternoon,

    You probably need a VBA solution for something like that, but I assume that the spreadsheet would have to be provided. In order to accomplish this with formulas, you would have to have something like:

    =SUM($A$1:A1) entered in cell B1 and then dragged across however many the maximum number of columns would be, with your data then pasted over top of it. I suppose you could have a second sheet with formulas similar to these, that pulled all of the data from an original sheet, but even that is messy.

    It may help to upload your workbook, or a variant of it.

    Thanks,

  5. #5
    Quote Originally Posted by iscreddy9 View Post
    It is not always D1 , See if i have 4 columns exist then my formula should be in 5 th column then formula should be E1 = A11, so that time the above formula is incorrect. It has to be dynamic by displayed columns.
    Just copy the given formula across!

    (Yeah, my 1,000th post).

Posting Permissions

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