+ Reply to Thread
Results 1 to 8 of 8

sum based on dates with specific cells

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

    sum based on dates with specific cells

    hello

    In F40 – I need a formula to work with the exiting formula to look at a date in f38 and then sum highlighted cells… sums between the dates in f38 & h38

    I’ve entered it manually at the moment to show expected results

    thanks

    please see attahed
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: sum based on dates with specific cells

    =IFERROR(INDEX('mfg weekly'!$A$1:$N$1240,MATCH(A40,'mfg weekly'!$A$1:$A$1240,),7)-SUM($J$6:$S$28*($J$3:$S$3>=F$38)*($J$3:$S$3<H$38)*($A$6:$A$28=$A40)),"0")
    Last edited by tim201110; 02-18-2019 at 05:10 PM. Reason: russian

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,375

    Re: sum based on dates with specific cells

    Translated:

    =IFERROR(INDEX('mfg weekly'!$A$1:$N$1240,MATCH($A40,'mfg weekly'!$A$1:$A$1240,),7)-SUM($J$6:$S$28*($J$3:$S$3>=F$38)*($J$3:$S$3<H$38)*($A$6:$A$28=$A40)),"0")

    Courtesy of https://en.excel-translator.de/translator/
    Last edited by AliGW; 02-18-2019 at 05:29 PM. Reason: Missing bracket added to translated formula.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: sum based on dates with specific cells

    Not sure I understand everything, but try something like this.
    F37 formula
    Please Login or Register  to view this content.
    Cell F40 formula and copy down
    Please Login or Register  to view this content.
    Greetings.
    Last edited by maras_mak; 02-18-2019 at 04:44 PM.

  5. #5
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: sum based on dates with specific cells

    Translated:
    =IFERROR(INDEX('mfg weekly'!$A$1:$N$1240,MATCH($A40,'mfg weekly'!$A$1:$A$1240,),7)-SUM($J$6:$S$28*($J$3:$S$3>=F$38)*($J$3:$S$3<H$38)*($A$6:$A$28=$A40)),"0")

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,375

    Re: sum based on dates with specific cells

    Please post your formulae in English in future, Tim, then there won’t be any need for translations. This is an English-speaking forum, after all. Of course, you could have just said thanks!

  7. #7
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: sum based on dates with specific cells

    Spasibo!________

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

    Re: sum based on dates with specific cells

    this also worked very well

+ 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. Replies: 13
    Last Post: 05-02-2016, 06:03 AM
  2. If dates are specific days, keep in specific cells
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-17-2015, 02:41 AM
  3. [SOLVED] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-20-2014, 07:42 PM
  4. [SOLVED] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 07:55 AM
  5. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  6. Replies: 1
    Last Post: 12-14-2011, 11:32 PM
  7. Replies: 1
    Last Post: 05-27-2010, 12:32 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