+ Reply to Thread
Results 1 to 2 of 2

sum the total quantity of sale on every 15 days

  1. #1
    Forum Contributor
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    233

    sum the total quantity of sale on every 15 days

    hi everyone. my query is regarding my stock sheet. in which we add the quantity as we manufactures and we do less as we sales.
    so i have to track particular quality with its particular design and with particular shade also. so that i can know which colour is in demand and therefore we can manufacture that. i want to see in every 15 day that how much every colour is getting sold.

    for example:- 3rd row (sheet 1)
    quality roman design no.1 and shade no. 1 from 1st december to 15 december total sale is of 13 pcs.
    i want this 13 pcs in sheet TRACK cell i3.

    please do this so that i can run this stock sheet according to my requirement i have a big sheet this is only for query.

    so as usual i am hoping this query will also be solved. so thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,572

    Re: sum the total quantity of sale on every 15 days

    This proposal adds a sheet row and then puts the two dates that were previously in I2 into different cells (I2:I3).
    The formula that then populates I4 is: =SUMIFS($N4:$CL4,$N$3:$CL$3,">="&I$2,$N$3:$CL$3,"<="&I$3)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Days since last sale
    By longhorn94 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-13-2018, 07:39 PM
  2. Update quantity in a cell after recording a sale
    By Excel_Ninja123 in forum Excel General
    Replies: 2
    Last Post: 08-10-2016, 10:06 AM
  3. [SOLVED] Running total of Quantity on Hand Vs Sales Vs Quantity to Produce
    By jespo1351 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2015, 07:34 AM
  4. [SOLVED] Counting Days since last sale
    By reglook0736 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-07-2015, 12:02 AM
  5. [SOLVED] How to calculate weekly sub-total of sale in a column with VBA.
    By sktneer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2013, 03:55 AM
  6. [SOLVED] define exact number of products sale from multiple sale and returned sale orders
    By maabadi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 06:14 AM
  7. [SOLVED] How to determine total value of business for sale
    By Margie Campbell in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-19-2006, 04:35 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