sold

I'm trying to count how many items have been sold each hour from a report. In example below between 10:00pm and 11:00pm I sold 4 items. I need to do this for each hour. How do I do a lookup for a time range? Thanks in advance! TIME Items Sold 10:41:00 PM 2 2:42:00 PM 1 4:36:00 PM 1 8:02:00...

I have several branches in a pivot table showing the total profit in a Column and the number of items sold for a particular item in another column I would like to know how to set up a formula to calculate the average Profit on the pivot table for each branch see sample data below...

Hi: I have been struggling for a solution and I need some help. Expected values are in column H to J In H2, I am looking for a formula for total cash due: = look up value in A2, return ticket price x tickets sold, less cash discount (per discount band) x ticket sold Excel...

Hi, i am trying to produce a spreadsheet that allows me to view how many items someone has sold per month. i am using the below formula but it doesnt seem to be working. if i take the date ranges out then if works but it gives the overall sales the person has had. i basically just want to add...

I am trying to get a total of units sold for a particular UPC. The units are not summed up before they reach me, so vlookup does not work here--first I need to get the total of the units, and then I need to input that total. I usually use a pivot table for this, but recently I've run into issues...

Good morning/afternoon everyone, I am in need of some assistance. Say I have a data tab where column A is a list of 100 stores, while column B is 'items sold'. In a second tab I have 5 cells in Column A that are dropdowns from the 100 stores, the 6th cell is "All Other". In column B is a...

hi all.. not a mathleet by any means.. I sold 1 of product A last year, i sold 2 this year.. % increase; (This year - last year) / last year = 100% increase I sold 5 of product A last year, i sold 0 this year using the same formula = -100% (shouldn't it reflect -500%)? thanks

Hello Folks, i am preparing the sales report of books. I want to filter a book name in column C and want to add the number of books sold. the result should be in next sheet column C book name and column D total sold quantity. Please see the example below. <tbody> C D Book A 1 Book B 3...

Hi all, Hope you can help me with this one. I am looking for a formula which will give me the date a product was last sold. In our BI system we have quantity sold and the date but nothing like last sold on. I have attached a file and am looking for a formula which will retrieve the info in G2...

Hey community, I have database in sheet2 which column A contains month names from january to december. and column b,c,d,e contains number of products sold in that month. i use datavalidation list ( months ) in sheet1 when you choose month from list, result of that month appears. (...

Hi Good evening, I am always happy to get your magical solutions for challenging questions... I am working in a excel which contains school bag, travel bag & lunch bag inward informations as below.. <tbody> s no date bag description rate qty total value selling price 1 01/12/2018...

Hi, I need some help with Excel to calculate ROI for this situation: <tbody> date quantity price bought quantity price sold ROI 2015-09-05 4,000 3.16 2015-11-05 1,500 3.56 2016-07-08 2,000 4.13 2016-11-10 2,000 4.51 2017-01-05 1,000 4.12...

I have the following data: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Jan Feb Mar Apr Apple 1 2 3 4 Orange 4 3 2 1 Banana 2 2 2 2 Apple 3 4 5 6 Orange 5 4 3 2 Banana 3 3...

So I'm creating a spreadsheet to track commission pay-out across multiple pools of business. I want to minimize the risk of my staff doing the % sum themselves but I cant figure out how to use the =IF function. The problem I have is that the commission is different based upon what is sold. For...

Hello, I need a formula to show the total number items sold each month by department then also count the total items sold by employee in that department. Please could you let me know what formula to use?

I have a pivot table that counts the number of items sold. The period covered is 7 months. I would like to know if there is a way to average the no. of items sold on the pivot table and if so how I go about doing this your assistance in this regard is most appreciated

Hi, I have an issue with a DAX formula and have spent over a week trying to resolve it. I would like to know the number of sale transactions each day. But here’s the quandary: If the total number of units sold after returns is zero, ignore transaction. If total units sold is >0 then count it 1...

Hey there, New to DAX so any help is appreciated. My goal is to understand how many customers cancel in a given sold date. Basically how many items did we sell in a given time period vs how many cancelled in that same period. What I'm trying to do is count the number of rows where [Cancel...

I have a workbook with 6 sheets...5 for each salesman and a total sheet. the sheets for the salesmen have an item number and quantity sold each month (13 columns total) I would like to summarize the sheets for the salesmen on he total sheet without using a pivot table. Also each sheet will...

I received some help on this Forum last October from Rick Rothstein creating a Random Number generator table, assuming 500 numbers (1 - 500). This Table is being used for a Reverse Raffle at a Charity Function in Ohio. To execute the macro, I am prompted to enter the first number in the Table...