profit

Hi, I am attempting to use a Sumproduct Froumla to work out commission but it isn't quite working. The below is what I am attempting. <colgroup><col><col><col><col></colgroup><tbody> Profit 1000 Starters 1 Actual starters 16 16000 Commision: 3194.8...

Hi, At the moment we have a separate workbook for each job that is going through that tracks invoices out against invoice in to show profit on each job. What would be the best way to create a monthly report in a separate workbook using data from each job workbook. I would like to get the total...

Good Morning, all. I'm a beginner with Excel and would like some help in figuring out the proper formula for the screenshot below. What I'm trying to do is be able to put in total Gross Profit for each day of the month and then have Excel tell me what I'm pacing to hit in Gross Profit at the end...

Hi, all. I'm trying to calculate a "capital preservation formula" based on stock positions, and it's not clear to me how to construct this in excel. Your starting equity is $50,000. Let's say you have a current total profit of $12,600 You have a open stock position where $4,200 is exposed in...

Hi, I am trying to total the sum of all items per day but only if another column is over a certain amount. My table looks like this: <tbody> Date<strike></strike> <strike></strike>Profit Rating 1/10 -7 1.9 1/10 10 1.6 2/10 10 1.7 2/10 10 1.86 3/10 -7 1.9 3/10 10...

This is a Qn pertaining to <tbody> <colgroup><col style="width:48pt" width="64" span="8"> </colgroup><tbody> A B C D E F G 1 2001 2001 2002 2002 2002CY-Q1 2 Sales Profit Sales Profit Sales...

Hi I want an Excel formula that will allow 1) match the Year in Row1, and match the Sales or Profit in Row 2 2) sum all the rows in the matched column EG, I want Year=2001 & Sales, so the formula will sum = 8559 + 4560 +1520 +1563 Thank you! <tbody> 2001 2001 2002 2002 Sales...

Hi, I hope someone can help, although i'm not even sure if this is possible. I have a spreadsheet where i enter purchase and sale figures of products, the number of transactions differ every day, one day it maybe two lines others it could be 3 or 4 lines Each line has three columns, buy, sell...

Hi, Please, can someone help me with an Excel formula for finding a Selling Price calculation based on known margin required & Cost Price (Ex. VAT)? Thanks Thanks

I would like a quick and easy formula to help calculate profit. Scenario. Suppose I purchased 100 Iphone8 at $1000 each plus 15% tax. In excel: A1=100 B1=$1000.00 C1=15% I tried to sell them and nobody would pay me over $1000.00 for them. So I looked around and found another provider that...

Hi Guys, I have Trial Balances of different divisions with same pattern in many different sheet. I have prepared a separate sheet which include the sum of certain codes of trial balance to make a profit & Loss A/C. (As an example all codes in the Trial Balance in All sheet starting with Digit...

Hi guys, Having a bit of a brain fart today and cannot get my head around this.. I want to be able input a COST (what it costs me) into lets say A2 I then want to be given a PRICE of what I should sell it for.. Fee's that are incurred are: 9% eBay Fee + 20% on top of that for VAT (so 10.8%...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to SUM the below categories based on texts description criteria as my below extract using vba. OPERAT. EXPENSES + FINANCIAL EXPENSES +...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, if is possible for anyone of you, I need your support so that to create a vba code, which should “SUM” rows based on text string criteria as my below extract. Should...

I would like code to exclude updating links in certain cells if possible where text "GP%" and "Net profit achieved" appears in Col A , then the formulas in the same rows as these must not be updated

Hi Gyus, I am a beginner in this forum. In my sheet attached below, I have 3 columns. A=S.No B=Customer C=Profit I want to calculate automatically, which customer is giving most profit out of these? below is link of my file Customer giving most profit.xlsx - Google Drive

NOG stands for Nett On Gross and is calculated by dividing cash margin ex VAT by retail sales including VAT. Whereas the standard method of working out retail margin is cash margin divided by retail sales excluding VAT. NOG example Retail Sales Price of Product X = £2.00 Less 20% VAT = £1.67...

I need someone to produce a spreadsheet to manage the following problem for us through providing a spreadsheet. "We are 3 people with 3 different bank accounts, we have decided to share the expenses and profits between us 30%, 35% and 35%. So what we need is an excel where we can enter the...

I'm trying to build a Profit and Loss for my company that is scalable. I've used the "Cascading Subtotals" post from the PowerPivotPro forum here: ( Profit & Loss–The Art of the Cascading Subtotal - PowerPivotPro) The problem I'm running into is with my slicers and the ability to cross filter...

I need to figure out how much I make per an AVERAGE client in a given month. I can either make $5, $10, $20, $30, $45 per client. I notice that most of my profit is in the $10 & $20, but I do sometimes make $5 and once in a while $45. Below are my numbers for the month of MAY <tbody>...