Results 1 to 4 of 4

Need a Formula to sum across columns for date + 14 months

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2013
    Location
    USA
    MS-Off Ver
    Excel 2013 2016
    Posts
    14

    Need a Formula to sum across columns for date + 14 months

    Please see attached file with sample data. In cell AL3 and AL4, I manually entered a formula to add the first 14 months of purchases and discounts across. Now in the next row, 5, I want the formula to start the addition in cell E5 and add 14 (exactly 14, not more, not less) columns across and display the result in cell AL5. The pattern should continue as long as there is data in the rows. Instead of doing it manually row by row, I’m hoping some formula will make it easier. Thanks in advance for your help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-26-2013, 09:48 AM
  2. Formula to add x months to a date when the date has passed.
    By adamliq in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-30-2013, 10:06 PM
  3. [SOLVED] IF AND or SUMIFS comparing Months from 2 date columns and text from 2 other columns
    By jrochet in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-22-2012, 11:06 AM
  4. Excel formula - due date for next 2 months
    By lilunaru in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2012, 01:12 AM
  5. [SOLVED] Formula: Date plus 3 months
    By Carly in forum Excel General
    Replies: 9
    Last Post: 05-19-2005, 04:06 PM

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