+ 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
    433

    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,359

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,013

    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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

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

    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,359

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,013

    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,359

    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
    433

    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