quantities

  1. J

    Summarize 3 Tabs into 1

    Hi all I have a customer order form spreadsheet with 3 existing tabs, each tab has a different product range and there are rows for each different product with columns for price, description, SKU and quantity ordered. I need some help please with what formula to use so that on a new fourth tab...
  2. J

    Trying to Create a Pricing Curve

    I have three quantities with prices: 30 - $6,313 100 - $5,592 300 - $5,261 I am trying to determine the price for each quantity in between the quantities above (31, 32, 33, 34, 35 etc). Honestly I am completely stuck and any help is greatly appreciated. Thanks!
  3. H

    Formula to order an item based on sales and quantity on hand

    Hi, I would like to create a formula where if I have sold more than 6 quantities and I have less than 3 in stock, it would ask me to create an order for 12 quantities. Thanks in advance. Regards, Hiten
  4. L

    Sumif filtered criteria

    I am building excel sheets to simplify my life with co-management that are not "EXCEL SAVVY". I came across a dilemma that made me feel like the un-savvy employee in this matter. For scheduling production needs i am using this formula to manage capacities of storage so i can reference this cell...
  5. bobgrand

    Data to appear when between 2 dates - Round 2

    OK, Let's try this again. I hope this makes more sense and look forward to see some responses if this is at all possible. I currently do all of this manually for a project that will be going on over the next 18 months. On the Due Day in column B, I would like to see the quantities in column A...
  6. P

    remove specific content of a cell to a new cell

    hi guys First time here! I have text data in a cell e.g. "Quantities: 2" or "Quantities: 3" etc. I want to be able to sum the fact that total quantity is 5 and I would normally do this by using text to column feature (fixed width) however is there a way I can extract or move just the number...
  7. M

    Create dynamic monthly quantities from weekly quantities for multiple data items?

    Hello, I am trying to aggregate weekly quantities into monthly ones. THIS LINK shows the dataset in question, the formula I created to aggregate these subsets, and the organization tactic I used. Is there any way I can make this formula dynamic? I feel like there is an easier way to do this...
  8. L

    Extract numbers from a cell keeping the quantities together

    Thanks you in advanced. I have a cell (say G11) which contains the following: 2+12+55+1+0+16+555+1= I need to extract all the numbers (automatically, with a formula or VB) into different cells keeping each quantity in it's own cell, for example: 2 will be in it's own cell 12 will be in it's...
  9. O

    Two Data Source Pivot Returning Field Total Sum Instead of Individual Values

    Hello, I'm trying to create a pivot using two data sources for the first time. I'm familiar with one-source pivots. In the same workbook, I have two worksheets which have inventory quantities by inventory part number. I am trying to make a comparison of the two. I followed the steps from...
  10. G

    Sumproduct? multiple columns with a criteria

    Hi all, I sure this will be an easy task for an expert.... C3:C30 contains prices D3:D30 contains a name F3:AH30 contain quantities For example, row 3 has a name "Ken" in column C, a cost of £2.00 in column D and a varying number of quantities in columns F:AH. I would like to multiply the...
  11. O

    Changing Line Graph Format

    Hello, I thought this would be simple to do but I am stumped by it so hoping someone can help me. I have a line chart with months on the x axis and the quantities on the y axis. All I want to do is have months on the Y axis and quantities of the x axis but just can't work out how. If Itry...
  12. F

    find duplicates in a column and sum

    Hi guys, im new here and have a question. I have a table with 14 colums. In colum D are costumer numbers. I want to check with a VBA if a costumer number inside more than one time. In colum C are order quantities. If the costume numer dublicate i want to sum all of the order quantities from...
  13. A

    Conditional Pricing Formula

    Dear Excel Wizards, Current Scenario Product Price : $50 Quantity : 10 Revenue : $50*10 = $500 However, how do I create a separate row denoting a promotion that shows that the buyer is only paying for 9 quantities for every 10 purchased. This will increase across the columns based on...
  14. T

    Grouping Challenge!

    Hello All, I'm new here, so please forgive my naivety. I've watched dozens of videos in an effort to resolve my issue, with no luck. So, I'm reaching out to the experts. Issue: I work for a printing company. We want to group art across the paper based on label quantities in the most efficient...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top