revenue

Hi all: I have sheet Revenue with: Column(A) = "Store_code", Column(B) = "Store_name", Column(C) = "Revenue", Column(D) = "Profit" Now I want to have macro to do that: with i = 2 to last row If Average(C2:Ci)>STDEV.P(C2:Ci) then if Ci-(Average(C2:Ci)+STDEV.P(C2:Ci))>0 then Ei.value =...

Hi, I'm trying to do a VBA script that will allow me to change what is shown on a pivot table I have build from my Data Model. So when I change the value in cell AO5, it will change from displaying Sum of Pax (sorted largest to smallest), to Sum of Total Revenue (largest to smallest). The...

I have 4 columns that need to be combined into 3 new columns Product,revenue,product,cost into a combined product, revenue, cost. The product data does not always have both cost and revenue so a zero will have to be added if product has only one. A $1 A .5 B $2 C .2 D $3 Result A $1 .5...

Hello I have mutlipe business lines each with many products listed with revenue show next to them. I want to vlookup from another cell/different tab all business lines and then capture and seum all monthly revenue into a single sell. Identify all the matchting rows: <tbody> Business 2...

I have a spreadsheet which I need to modify a bit with a much more complicated formula. Hoping someone can advise. Here's the existing formula in C2. <tbody> Classification Revenue Jan Feb Mar Apr Conv Date New Business $500K if(ConvDate>C1,0,B2/12) Jan 15 Upsells $1M Feb...

I have a pivot table which has various fields, including Serial #, Date, and Revenue. The Revenue appears fine as long as I don't have a date, but when I bring in the date field it somehow gets messed up. The Revenue column disappears, and instead seems to somehow become a row on top of Serial...

I am needing a formula in my revenue column is only added for the Quarter chosen in column A <tbody> Quarter Revenue Q1 500 Q2 250 Q3 350 Q4 100 Q1 2500 </tbody> I want a formula that will extract only the revenue for each time "Q1" is listed. This can not be a pivot table, as it...

Hi, I am not sure how to accomplish the following, hope you can help. I have a spreadsheet named "Upload" and on column "I" I have a string of data (Variable rows). I want to look at the first 4 numbers on that string and if it's greater than or = 4000, then type in cell on the left "Expense" or...

Currently manually updating about 30 charts monthly. Adding new data monthly. Would like to make charts dynamic I would like to use the offset function and named ranges. I can get as far as one dimension and one series but I am stuck as to how to use both series (revenue and volume). But I...

Hello, I am trying to come up with a formula that i can drag to sum just the weekdays from the data set up below: <tbody> Weekdays 2019 Rooms Revenue Casino Formula Formula Events Formula Formula </tbody> Data looks like this: <tbody> Casino Casino Events Events 2019 2019...

Hi - I am trying to create a formula to determine revenue share for a company I work with. The initial revenue share percentage is 5%. On a yearly basis, Company X will receive 5% of Company Y's revenue until a $12 million cumulative number is hit. Once $12 million is hit, the revenue share %...

I suspect I need to use a different function but I am trying to lookup data and in one tab the city name is in one column, but the tab with the data the city names are spread out over manmy columns. <colgroup><col><col span="3"></colgroup><tbody> Location Revenue Expenses Boston 150000...

I have an excel tracker that has a list of prospective customer and customers it has all their information and I added a column for expected revenue (I1-I32) and then Generated sale (J1-J32) which the sales rep will enter Y for Yes or N for No I have a total column at the bottom - I have summed...

Thank you for any assistance you can give, I am trying to sum the revenue for each carrier based on the date and get the average for each carrier per month. I have the following formula which nets me the average per month based on all carriers, but I can't figure out how to obtain the results...

I'm trying to update a worksheet, and HATE continuously editing cells. ie. +5204.52+2345.61. In my spreadsheet, I have the following sample data: Week ending dates in D2:D5 Revenue Center names in E1:J1 Sales data in E2:J5 I have the same Revenue Center names in A2:A6, and a single date in...

Desire: I am trying to create two macro buttons side by side at the beginning of each of my "active" rows, that will cut the row and either insert it above or insert it below the rows current location depending on which button is pressed (The first button would say Up or have an Up arrow, the...

I am trying to remember how to use the conditional formatting function to account for press size vs hourly revenue. For example, if the company is running a 300-400 ton press, it should have a net revenue of at least $50 (hourly). I was wondering if there was a way to just input the press size...

Hi, I hope I can explain myself properly to get some assistance here. The below data is on my first tab in excel, and I am trying to gain a understanding of how much Actual Revenue a specific marketing event brought in. <tbody> Marketing Event # of Contact Customer Name Cost...

<tbody> Account CC Acc-CC Descr Jan Feb Mar Apr 301000 000 301000 000 Alt Rev 0 0 0 0 301000 100 301000 100 Alt Rev 500 500 200 400 301001 000 301001 000 Revenue 5000 8000 10000 6000 301001 100 301001 100 Revenue 0 2000 5000 8000 301001 200...

All I am trying to say is I want the sum of column D if no value in my defined named revenue (KNOWN_REVENUE) matches anything in column C. This is probably way off. =SUMIFS(D:D,C:C,<>KNOWN_REVENUE) Here is an example. KNOWN_REVENUE APPLES PEARS ORANGES column C column D APPLES...