+ Reply to Thread
Results 1 to 7 of 7

=SUMIF counting product to count date specific

  1. 03-22-2018, 04:36 AM #1
    rodgerdooter
    rodgerdooter is offline
    Registered User
    Join Date
    06-23-2015
    Location
    oswestry, england
    MS-Off Ver
    2010
    Posts
    63

    =SUMIF counting product to count date specific

    hi all , im having a little bother with a formula that counts my projected stock - it counts 3 days worth and I need it to count how much projected I have for each day going forward


    in my tab "weekly optimisation report" column f g and h are what I project to make for the next 3 days when A matches T in flowrap generation

    like so
    =SUMIF('flowrap generation'!T:T,'weekly optimisation report '!A8,'flowrap generation'!V:V)

    I need it to split the figure so it also matches the date in "weekly optimisation report " F7 , G7 and H7 when the same date appears in flowrap generation column B

    I hope that all makes sense :-)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-22-2018, 08:42 PM #2
    Syrkrasi
    Syrkrasi is offline
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: =SUMIF counting product to count date specific

    Try this in
    For F8: =SUMIFS('flowrap generation'!$V$2:$V$135,'flowrap generation'!$T$2:$T$135,$A$8,'flowrap generation'!$B$2:$B$135,F$7)
    For G8: =SUMIFS('flowrap generation'!$V$2:$V$135,'flowrap generation'!$T$2:$T$135,$A$8,'flowrap generation'!$B$2:$B$135,G$7)
    For H8: =SUMIFS('flowrap generation'!$V$2:$V$135,'flowrap generation'!$T$2:$T$135,$A$8,'flowrap generation'!$B$2:$B$135,H$7)
    If your original question was resolved, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Click on the Add Reputation button (located at the lower-left corner of all post) for those who assisted you in solving your issue.
    Reply With QuoteRegister To Reply
  3. 03-23-2018, 03:25 AM #3
    rodgerdooter
    rodgerdooter is offline
    Registered User
    Join Date
    06-23-2015
    Location
    oswestry, england
    MS-Off Ver
    2010
    Posts
    63

    Re: =SUMIF counting product to count date specific

    ok

    I have placed that in , and whilst it gives no error its not counting anything either
    I assume its a text or numeric issue
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-23-2018, 03:51 AM #4
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: =SUMIF counting product to count date specific

    There is no problem with the above formula.

    The reason why it is not producing the result, the date 23, 24 & 25 Mar, 2018 is not exist in flowrap generation sheet for code 1083573.

    Hope this will help you
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  5. 03-23-2018, 09:58 AM #5
    Syrkrasi
    Syrkrasi is offline
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: =SUMIF counting product to count date specific

    As shukla.ankur281190 has pointed out, there isn't anything wrong with the formula. However, I've noticed that you had dragged the formula down. If your going to do that please edit the formula to the following.

    The edited area is in Red
    For F8: =SUMIFS('flowrap generation'!$V$2:$V$135,'flowrap generation'!$T$2:$T$135,$A8,'flowrap generation'!$B$2:$B$135,F$7)
    For G8: =SUMIFS('flowrap generation'!$V$2:$V$135,'flowrap generation'!$T$2:$T$135,$A8,'flowrap generation'!$B$2:$B$135,G$7)
    For H8: =SUMIFS('flowrap generation'!$V$2:$V$135,'flowrap generation'!$T$2:$T$135,$A8,'flowrap generation'!$B$2:$B$135,H$7)
    Reply With QuoteRegister To Reply
  6. 04-18-2018, 05:10 AM #6
    rodgerdooter
    rodgerdooter is offline
    Registered User
    Join Date
    06-23-2015
    Location
    oswestry, england
    MS-Off Ver
    2010
    Posts
    63

    Re: =SUMIF counting product to count date specific

    I never thanked you guys for this

    you both are indeed correct - there was nothing wrong with the formula - it was because sheet ones date automatically had updated based on =today() but I had not updated the stock sheet
    Reply With QuoteRegister To Reply
  7. 04-18-2018, 07:35 AM #7
    Syrkrasi
    Syrkrasi is offline
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: =SUMIF counting product to count date specific

    Glad that we were able to assist you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumif to count up specific date
    By sipa in forum Excel General
    Replies: 2
    Last Post: 01-16-2016, 05:46 PM
  2. Formula to count last 18 instances of occurrence (from a specific date) to perform a SUMIF
    By CRMORE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2015, 08:03 AM
  3. CountIf or SumIf? Counting text values in a specific date range
    By ccarmichael in forum Excel General
    Replies: 5
    Last Post: 05-04-2015, 04:36 PM
  4. Count Product codes by date and sum weight
    By Matt_IT in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2012, 12:44 AM
  5. count product based on date
    By sc11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2012, 08:37 AM
  6. sum product to count data in a date list
    By thompsy121 in forum Excel General
    Replies: 12
    Last Post: 02-24-2010, 04:13 AM
  7. Counting Number Of passes & fails by date + product
    By ajxxx in forum Excel General
    Replies: 2
    Last Post: 01-06-2009, 07:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1