cost

I have a pivot table with a ****load of fields. It would help if I could insert calculation fields within the pivot itself rather than doing it externally. With the data below I'd like to create a field which shows the Profit per Order and the Shipping Cost per Order. I went to the Analyze...

When I open my spreadsheet and delete contents out of a cell, I get a type mismatch error. This is my code: Private Sub Worksheet_Change(ByVal Target As Range) 'ActiveSheet.Unprotect Dim ans As String If Not Intersect(Target, Range("A:A,B:B")) Is Nothing Then...

I have this setup: ``` date cost 22 march 2018 100 10 january 2018 20 15 march 2019 150 12 january 2019 133 ``` I don't know in advance, which cost, dates or how many rows I'll have. Need a measure that...

Good afternoon, I am trying to complete an index & match query to return a title from column "H" based on the following criteria M20 - Book type (hardback or Paperback) M21 - cost to me N21 - cost to customer M20 And column "H" are set as text values and M21 & N21 are as numbers Both are...

For the pros… Been working on this for the last day…. I have a monthly report that update each week. It consists of cost center and account number. I want to control the budget and have the total of each account for each cost center. Not very complicated up to now… Here is the fun part: I have...

Hi, I am currently working on a worksheet, and on the sheet there are 4 tabs which have the same layout but each is a different cost centre. I need to do a check to see if one number on a master tabappears on any of the 4 cost centre tabs. Basically I need a vlookup across the 4 tabs but in...

Hi, I am hoping someone can help! I am trying to set up a spreadsheet for an online business that updates the 'cost of purchase' depending on which stock order has been sold. For example, if I order 10 units of soap at $10 then the cost is $10. If I make a second order of 10 soaps at $12...

I have a fairly simple model that has 10 steps and the time & cost of each step. <colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> ID Activity ActivityTime Activity Cost...

My spreadsheet looks like this: <tbody> Total Collected After Shipping & Fees Amber List Cost Estimated Profit Profit Margin $50.36 40.00 10.36 ? $13.35 10.00 3.35 ? </tbody> How do i calculate the profit margin?

Hi I think this may be an Index/Match formula but not 100% Trying to work out a cost based on two factors as displayed below. <tbody> Hardware Category Berlin Amsterdam London Frankfurt Copenhagen Lisbon Madrid Barcelona 1 £175 £175 £35 £175 £135 £235 £235 £235 2 £185...

Hi Folks, I have a data set which has role titles in the first column and country names as headers. Each column contains a role cost for each country. I am trying to create a dynamic Data Validation list where it will show only roles where cost is greater than zero for the country selected...

I would like to calculate current depreciation which should not exceed the cost of the asset, which is in cell b2. Thanks. The current depreciation is being calculated as under: =IF(A8="","",ROUND(IF(A8=1,SLN($B$2,0,$B$3)/12*DATEDIF($B$4,$B$6,"M"),SLN($B$2,0,$B$3)),0)) <tbody> A B C D E F...

Hi Everyone I have two spreadsheets. Sheets(1) is with unknown number of columns and rows. Sheets(2) is a list of profiles and rates. I need to look up the specific rate in Sheets(2) for the specific profile in Sheets(1). In Sheets(1), there are headings for 'Profile', 'Cost' and 'Rate'...

Hi all, New user and couldn't seem to find exactly what I was after, so hopefully below makes some sense. Context: I'm looking at utility spend across our portfolio of around 100 locations, each location is a different size and spend is location specific. What I'm trying to pull out is any...

Hi guys, I am in the process of running a planning cycle and have currently I have managed to design what the template will look like for one area i.e. EMEA. We have numerous areas which have multiple cost centres which are further broken down into accounts at hierarchy levels 1 and 2. I am...

If I have in cell A1 this value [CLIN 0010 MATERIAL COST SUMMARY A3382276.xlsx] can I write a dynamic formula that uses this value? Sort of using a concatenate This is my formula. But I want to change it so that the part that says [CLIN 0002 MATERIAL COST SUMMARY B53388.xlsx] is dynamic...

I have a user form that I would like to modify the code on, It has a list box that pulls up a part#, then it has a text box for the cost of that part. In the text box I would like to do a vlookup that refers to the list box and pulls in the cost from a table. Currently the text box has this...

Hi All, I need a Excel formula to calculate my selling price based on a predetermined profit. What is know is: 1) The final profit after all the cost ($20) 2) The item cost 3) The merchant fee which is 10% (0.10) 4) The payment processor fee which is 2.9% + $0.30 5) The shipping material cost...

Hello! I would greatly appreciate assistance in finding a solution in the excel ribbon or a VBA Code to automate the following task. I am creating a spreadsheet that is a download of all purchases that I have made for my music store since opening 6 years ago. Each row represents 1 item on a...

Hi, I am wondering what creates the following Pivot table view. It seems that the view changes when you start messing with the ordering of the values, and you can never get it back the way it was. When you have a pivot table with multiple Values in the values box, the pivot table will sometimes...