+ Reply to Thread
Results 1 to 2 of 2

Add data in multiple columns (dynamic # of columns)

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    1

    Add data in multiple columns (dynamic # of columns)

    Hi all,

    I'm creating a budget spreadsheet that is going to have multiple months in it (in a single sheet). Each month has four columns, and one of those columns is "Amount budgeted". Now, as I add extra months to the excel sheet, this column starts repeating (per month). To get some calculations going, my current goal is to add the value in each "Amount Budgeted" column that repeats for every month.

    In other words, I have a 100 rows, with interesting data in columns 10, 14, 18, 22, 26 and so on. If the current column that I'm working in is Column 30, is there an easy way/formula to find the sum of past columns?

    Hope this makes sense!

    Thanks

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    23,777

    Re: Add data in multiple columns (dynamic # of columns)

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

    Please read the yellow banner at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn



+ 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