+ 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
    2010
    Posts
    275

    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
    2016
    Posts
    1,322

    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)

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