Results 1 to 7 of 7

=SUMIF counting product to count date specific

Threaded View

  1. #1
    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

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. Replies: 3
    Last Post: 08-04-2015, 08:03 AM
  3. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1