sales

  1. P

    Return Sum of Multiple VLOOKUP results?

    Good day everyone, Yet again I have returned with an inquiry. I am trying to work on this sales file where I wanted to extract the daily sales. Here's the screenshot: (Screenshot below is just a part of a big raw file which contains over 6 months worth of sales data) Now, I was able to...
  2. P

    loop through each last row

    Hi, I have workbook. In sheet 1 I have below <tbody> Customer Name Sales Amount Customer A Customer B </tbody> it continuous n number of customers. And sheet 2 name is Customer A, sheet 3 name is Customer B.. sheet 4..sheet 5 Customer N number.. Each customer sheet has sales...
  3. S

    Dax need to calculate current QTD Sales

    Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD. So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year. This is my MTD formula: =if(month(dCalendar[dateS])=month(today()) &&...
  4. V

    Day on day comparison

    Hello all I hope you can help on this formula, I want to try to compare day on day sales comparison over 2018 / 2019 At the moment I have a sumifs statement that just adds up for each month and a running total for the year, it's fine for this year as it will add up to today but last year...
  5. gravanoc

    Can this scenario be modelled within Excel?

    The purpose is to ensure that an expected number of new clients will be served by a sales representative on schedule. Normally, you hire sales reps and then get clients, but for the purposes of forecasting I need to do it the other way around. Each sales rep, newly hired, has a training period...
  6. A

    Runtime Error 1004: Unable to get pivotfields property of the PivotTable Class

    Hello Community, Looking for a little VBA love. Current macro simply done by recording. So I couldn't screw up the language code. I have 2 sheets: 1 for Brands and Brands Top Gain Loss. I would like to get rid of one sheet and allow a macro for Sort by "Dollar Sales" and "Dollar Sales Chg YA"...
  7. C

    AVERGEIFS and OR formula

    Hi I have the following to return 2 seperate numbers: =AVERAGEIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,"Surrendered") =AVERAGEIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,"Current") How do I get an OR statement into it so it brings back a...
  8. C

    Check each row for criteria and delete that row and the 2 below it

    <tbody> SKU Type KW1 KW2 KW3 SUM SKU1 Actual Sales 30 41 28 99 SKU1 LY Sales 46 41 25 113 SKU1 Forecst 40 42 43 125 SKU2 Actual Sales 1084 793 2022 3899 SKU2 LY Sales 950 958 765 2672 SKU2 Forecst 871 790 1659 3320 SKU3 Actual Sales 44...
  9. E

    Formula for YTD (year to date)

    Hi: Can someone please help me with this? I have the monthly sales organized in this way: Jan-19 (Column A), Feb-19 (Column B), Mar-19 (Column C), ...., Dec-19(Column L) I would like to calculate the YTD (year to date) sales based on a picking list (I now how to do the picking list). For...
  10. megera716

    Formula to identify how long before cell value changes

    I feel like that's a weird subject but here's what I'm trying to do. I've analyzed year over year sales by customer and identified when a customer was new, if they were an existing customer but their total sales increased, decreased or stayed flat YoY, or if they were lost. (None would indicate...
  11. M

    Help required with formula

    Hi, I need help with a formula that works out a commission based on the number of sales you get. The ount of commission you get is tiered dependant on number of sales 1-4 sales = £5 each 5-9 sales = £7.50 each 10+ sales = £12.50 each I have tried using a formula with IF statements but that...
  12. A

    Setup Multi Variable in Excel

    Hi All, Currently, I'm trying to resolve TSP problem regarding number of people need to cover stores in a day. What I'm thinking currently is to setup a constraint and actual working minutes & velocity to travel to stores as per current below. However, I'm stuck with the formula on how can I...
  13. S

    VBA: Error with adding datafields to a pivot table

    Hi guys, I have some code that does its job in adding datafields to a pivot table. I linked it with a form control button: Sub PDA1P() ' ' PDA1P Macro ' Adds all 1P PDA columns into values of PT ' ' Keyboard Shortcut: Ctrl+Shift+P ' ActiveSheet.PivotTables("SpendTable").AddDataField...
  14. V

    Formula to calc YTD Target

    Hello all I hope you can help on this one Column "M" is a sales value Column "Z" has a Sales persons name in Column "H" date the date format "2018-01-19" Column "F" has the year Cell "D4" has the sales person's name in (Drop down Table) Cell "D7" has the Year" (Drop down Table) I have a...
  15. P

    Lookup function for sales tracking workbook

    Hi friends! Looking for some help here with formulas (trying to do this without VBA); I've done something similar years ago and can't remember how I did it! :( I am working on a sales tracking workbook. I have Zapier dumping raw data into the workbook from my transaction database and am...
  16. gravanoc

    How to Calculate Number of Sales Reps needed based on Expected Clients

    I have a problem I'm trying to analyze. We have to do an analysis on how many new sales reps to hire based on the number of expected onboarded clients. The dynamic part of the problem is that when we hire a sales rep, they have a 2 quarter training period, after which they are able to make a...
  17. T

    Macro to fill in dates from one sheet to another finding the account line?

    Hi Everyone, I have two sheets. 1 "Raw Data" and holds a list of sales 2 "Sales" and is my official Sales list. I need to update one column in Sales with the new data from "Raw Data" so heres what I need. In "Raw Data" column A has a Ref Number. (that's rows 2 to last row) In "Sales" the same...
  18. D

    Not calculating in a pivot table

    I have a table of data with three columns: - company code - company name - sales When we use Pivot Tables, we would drag, say, Company Code to the rows field and Sales to the total field. But how about if we wanted to see the company name corresponding to the company code... how would you go...
  19. U

    Pivot table question

    Hi there, is there anyway that showing data "as a percent of' will relate to the entire dataset? Meaning, for example, that if I have a data-set of car models sales by car makers and I choose to filter 'Audi' in the pivot-table- The percent of sales for A3 model will be in relation to the...
  20. W

    Formula to find the correct column in a range, and sum the values in that column according to multiple criteria

    I have a report that I receive weekly Column A will always be Region Column B will always be Color Columns C through Z may change, the order may change, a column that had activity the prior week might not exist because their is no activity. The headers in Column C through Z are known to me...

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