+ Reply to Thread
Results 1 to 3 of 3

Sum between dates for a specific column and specific time frame

  1. #1
    Registered User
    Join Date
    09-13-2019
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    2

    Sum between dates for a specific column and specific time frame

    Hi,

    Thank you for reading this. I have attached a sample data sheet to this post.

    2 formulas needed:

    1- I am trying to sum data for a office for the current year. (All 2019)

    2-Then I am trying to sum data for the previous year through same time frame. (1/1/2018 - 10/20/2019)


    I can use this =SUMIF(A2:A9,"<="&D14,INDEX(B2:D9,,MATCH(D13,B1:D1,0))) to get the total sum for correct column -but I need to get the date range implemented for them.

    Thank you for your consideration.

    -David

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,776

    Re: Sum between dates for a specific column and specific time frame

    C16=sumproduct((year($a$2:$a$9)=year($c$14))*($b$1:$d$1=$c$13)*($b$2:$d$9))

    c17=sumproduct(($a$2:$a$9<=$c$14-(52*7))*($b$1:$d$1=$c$13)*($b$2:$d$9))

  3. #3
    Registered User
    Join Date
    09-13-2019
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    2

    Re: Sum between dates for a specific column and specific time frame

    CARACALLA

    Thank you so much! Works great.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count specific day between fixed dates, with user input controlling time frame, month/s
    By Joe Bob Crain in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-12-2017, 04:16 PM
  2. [SOLVED] Calculate OVERTIME DURATION in specific time frame
    By Intalzky in forum Excel General
    Replies: 4
    Last Post: 02-10-2017, 05:18 PM
  3. Tally of calls occuring during a specific time frame
    By clairebarnes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2016, 09:26 PM
  4. [SOLVED] time line adding a specific time frame in each additional cell
    By RobertM01 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-23-2014, 10:22 AM
  5. Sum number of calls within a specific time frame
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2013, 11:38 PM
  6. [SOLVED] Assigning a category to a specific time frame
    By Woofaloo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-18-2013, 07:15 PM
  7. Excel 2007 : Adds values for a specific time frame
    By Raist23 in forum Excel General
    Replies: 3
    Last Post: 03-15-2012, 05:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1