sales

Dear Experts, I have a big excel workbook comprising of sales data for various sales person. Each sales person's data is maintained in separate sheet in the master workbook. At the end of sales date worksheet have the detailed data for every sales person. I want to create a summary of detailed...

Hello, Please see the table below: <tbody> Store Name Sales 2018 Rank Store Name Sales 2019 Rank Store A 700 1 Store B 400 1 Store B 500 2 Store A 350 2 </tbody> I am looking to do two things: 1. I need to find the difference in sales for...

Hi; I did see this question asked before, but I couldn't find a thread with a posted answer. I'm mostly frustrated because I'm 90% sure it's a stupid simple fix, but I can't seem to get it... I'm trying to copy a graph format from previous reports so that it's consistent. I've got a stacked...

Hi Is there a way to sum one column only if the values in another column are populated? So in the example below, there are 5 products: A - E in column A. Column B states whether or not a product is 'Live' And column C has the sales data for that product. I'd like to sum up the sales of...

I have a data set that includes a field for Year among other fields like Sales. I would like to create a Pivot Table where Change (in Sales between the two years) would replace Grand Total. How can I do that? I have Year in the Rows and Sales in Values, but Grand Total adds the two together...

I am using the following formula to check if a contact's job title, stored in cell K5, is found in a named range of job titles. SUMPRODUCT(--ISNUMBER(SEARCH(LeadershipTitles,K5)))>0 The problem is that this formula returns TRUE when the value in K5 is "Sales Coordinator" but that text (i.e...

Hello Team! I am new to the forum though i use to regularly get help from the posts as a guest. I am hoping a question of mine would be solved:) I have a table with lot of data of opportunities in Pipeline from different departments in the organization, i want to get the Top 10 values based on...

Hello - it's a while since my last question, but I'm totally stuck on this one. I have a sales database which includes multiple columns and my basic quest is to have a formula that establishes if a product has had sales in the latest week so a linked table can say listed/delisted. The latest...

Hello, thank you for taking time to read my message. I need some help, and after searching, I dont seem to find the answer. Hopefully, I can find help here. The goal is to sum revenue based on a average sales price per item. I want to group this sales based on price point to learn the...

Hi, I have a sample data as below, original data is around 90 thousand. Please Note:- That in the below sample data the value in the column "Approval Status" is show "Approved", but this is not the case it can be other values as well for example like "Rejected" or "Submitted" etc., Sample...

Good Day Ma'am/Sir. I am making a code for which i have a worksheet 2columns Dates,Sales. I want to make a userform which i can choose years in combobox and display and sum all the sales within each month in the list box. I manage to find a tutorial but it has some minor issue. it display only...

Hi All, TL;DR: Need to figure out how to formulate the remaining sales dollars required based on how many selling months are left, based on what month it is, and put the remaining sales dollars required as an average line in a chart. - description I can get the average line on the chart no...

Hi. I have a sheet where I am working out product sales. In Sheet1 Column A I have all my SKUs. Each week when I product a report I want to store the current sales into Sheet2 so I can look back over time. The problem is, as we add new products, the list of SKUs in Sheet1 will grow. So I...

Hi All, I have a question about Pivot Tables. Not exactly sure how to describe this but I'll try It's about Row Labels. When there is one entry in a row everything is fine eg Material Number Sales 2019 Sales 2020 123456 555000 600000 But if I add a row in an...

so..... this seems to be pretty straightforward but for the life of me i can't seem to think of a formula that could work with this.... i have a list of salesmen who well.... made sales... and i need to count the amount of sales per salesman, however, the salesman nema only shows up once per...

Hi please someone help me to make a sales report as per the attached sheet as in the Sheet2 . If someone help me I will be very thankful. https://www.dropbox.com/s/6lcxtojqs8s977x/Dummy.xlsx?dl=0

Hi All, I have a bit of a challenge... I use this retail software that spits out these awful csv reports that don't provide the information I need -- unfortunately it lumps all sales together, whether they are actual sales or comps. I want to create a formula or formulas to isolate all items...

hi all i have a table that list all my s/m and their Total sales for the year i have another table with other totals for each s/m i would like to know the percentage of that other number compared to their total sales like (=A1/AI14) how would i get that done ? i want it to match the s/m one...

<tbody> <tbody> M N O P Q R S I put staff no. in here I have a formula in here when it generates sales person name after entering her staff no. in column M - formula is =INDEX('Staff info'!$a$3:$a$22,match($Q2,'Staff Info'!$G$3:$G$22,0)) Formula in here for single sales...

Hi, I am wanting to have 3 pivot charts that change automatically, but all showing different data. So far i have my pivot showing A = Months B = Percentage C = Sales D = SIH (stock in hand) I have a pivot chart working no problem for the first column which is percentage, i have tried...