+ Reply to Thread
Results 1 to 2 of 2

sum based between dates. with out effcting current formula

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    sum based between dates. with out effcting current formula

    hello All

    Please attahed

    T6 = sum up G6 I6 K6 M6 06 based on the date between T5-U5, then minus the T6

    There hidden cells in the blue and white section

    Yellow is the expected outcome for dates between 18th Feb and 25th
    Green is the expected outcome for the date 25th

    The dates change daily so the formula needs to read the dates

    any help would be great
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: sum based between dates. with out effcting current formula

    A sumifs formula will do: =SUMIFS($G6:$O6,$G$5:$O$5,">="&$T$5,$G$5:$O$5,"<="&$U$5)-$T6
    Click the * to say thanks.

+ 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] Date Based Conditions - Target Dates and Current Status.
    By JasonMcQueen in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2018, 09:51 AM
  2. [SOLVED] Current progress calculation based on dates
    By kriminaal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2016, 04:13 PM
  3. Filter Pivot Table Based on Current Dates
    By mrblue1123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2016, 06:47 PM
  4. [SOLVED] Deleting Dates based on the current date
    By John Swift in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2014, 10:07 AM
  5. combining text from rows based upon current month dates
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-26-2014, 03:42 PM
  6. Replies: 0
    Last Post: 06-23-2012, 01:38 AM
  7. Calculating dates based on the current date
    By DavidW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2006, 08:50 AM

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