Results 1 to 7 of 7

SUM Across Multiple Columns, IF within specified Date AND date plus 12 Months

Threaded View

  1. 07-23-2018, 11:12 AM #4
    DTK0902
    DTK0902 is offline
    Registered User
    Join Date
    03-07-2018
    Location
    Belfast
    MS-Off Ver
    2017
    Posts
    13

    Re: SUM Across Multiple Columns, IF within specified Date AND date plus 12 Months

    Hi,
    Thanks for the reply, I've attached a cleansed version to this post.

    The expected results are that ROW 2 should be populated with any the income generated from any sale within that month, ideally over the life of the contract.



    Thanks in advance,
    Daniel
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting with Multiple Criteria - Months and Date Differences
    By kujoking7 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-14-2017, 04:58 PM
  2. [SOLVED] Creating a view by filtering 2 columns by date (both within 3 months of today's date)
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-21-2014, 05:04 AM
  3. [SOLVED] Add date + 3 months in vba so the VBA sends mail reminder exactly 3 months before due date
    By JimmyQ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2014, 08:54 AM
  4. [SOLVED] Need a Formula to sum across columns for date + 14 months
    By sunirone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2013, 10:49 PM
  5. [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
  6. Given a date......find the same date two months prior to the given date
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2012, 11:24 PM
  7. Given an end date find corresponding start date 3 months prior ..quarter date range
    By welchs101 in forum Excel General
    Replies: 2
    Last Post: 01-04-2012, 09:15 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1