Results 1 to 8 of 8

Sumif or sumproduct formula for a rolling calendar

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    365 MSO
    Posts
    473

    Sumif or sumproduct formula for a rolling calendar

    Hi,

    I have sheet 1 where it's a rolling 3 year calendar. Sheet 2 has my data. My goal is to be able to have a formula recreate the numbers I manually summed. I want it to look at the dates, and sum only data is 3 years, or under from the date listed. Once it goes past 3 years, it should no longer be included. My real data set has a lot more data, and goes out more years. This is just a quick example

    Thank you
    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. [SOLVED] Rolling Calendar forumula to be used with another formula for acquiring numbers for months
    By RickMadsen in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-12-2014, 08:52 AM
  2. Rolling Calendar array will not work for a completely horizontal calendar
    By Michaelwk10 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2014, 05:11 PM
  3. Sumif formula for a rolling 45 day period
    By meilieng in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-05-2012, 08:39 PM
  4. [SOLVED] Rolling Calendar
    By MrBen via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. Rolling Calendar
    By MrBen via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  6. Rolling Calendar
    By MrBen via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  7. Rolling Calendar
    By MrBen via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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