revenue

Greetings all and happy new year - sorry for the solicitation but desperate to get this working asap to avoid manual work :) !!! I'm trying to create a formula to accomplish the following. I am looking for a completed excel template I can use and post the formula/excel file here for others'...

Hi all, A pretty simple question but I am stumped. Say I have "Room Revenue" for 30 days in the month of October. Room Revenue | 30,000 |1st Oct Room Revenue | 30,000| 2nd Oct Room Revenue | 29,000 | 1st Oct Is there any way I can get the final value to sum up all Room Revenue for 1st Oct...

I can't believe there isn't an easier way to do this ... I have my data set up as follows: <tbody> Jan-17 Feb-17 Mar-17 Apr-17 Revenue beginning month 100 105 110 115 Gains 10 10 10 10 Losses (5) (5) (5) (5) Revenue end of month 105 110 115 120 </tbody> The list of columns...

Hey folks, trying to build a sales report in Excel, which sums up all the sales on a product level. For each product I have multiple sales people, each of which has his own sheet. Lets say this is the structure: <tbody> Formula-Sheet Report-Apples Apples-John Apples-Mary Apples-Donald...

Hi guys, I have a dataset which has a column of customer numbers and then columns of revenue by date (B to CX) and then also have a column (CZ) of date for an email sent. I want to look for the last date of revenue before the date of action. So if the email was sent on 06/11/2017 I want to...

I am building a template that has the revenue forecast over time and multiple different scenarios will be run through this ONE single template. There are some scenarios where revenue cuts off at 2022 for example and some where it cuts off at 2052. Thus, I have to have the same chart, but since...

I have a dataset with about 500 rows, each row resembling a page. Each page had so many visitors, generated x amount of dollars, and had x number enter on it as their first page view. I'm trying to give an overall rank for each page based on the visits, revenue, and entries and compare across...

I am completely lost and I am not sure what function or formula will pull the correct period if the data changes. Can you please help. What period do we start to see revenue? <tbody> Period Revenue 1 0 2 0 3 0 4 0 5 0 6 10 7 10 8 25 9 30 10 50 </tbody> What formula...

Hi, I have a pivot table that has a number of values including revenue and volume and filters on a date range. The issue is if I change the date range the column called <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit...

Folks, Hopefully a simple query. In simple terms, I have a large list (circa 40k) of timesheet entries (in a worksheet named 'Timesheet Entries') with three columns: a) Column A: Staff Name b) Column B: Time (hours) c) Column C: Hourly Rate In a separate worksheet ('Report' / Column A), I have...

Hi everyone, At a high level, I have to summarize data into a summary. I am given an excel that has the hours an employee has worked as well as how much an employee can charge to clients per hour. This is then multiplied to get to a revenue amount (Est) that we would charge out. The things is...

I have a table with invoices and revenue. Invoice Revenue A 200 B 600 A 500 C 400 The output I'm trying to get is the number of unique invoices less than 500. So this example, it would be one invoice, "C" for 400. The DAX formula below, sees...

SUMIFS difficulty...need help with a lookup type formula, probably not even a SUMIFS? Finding or matching Lease Number, Period, and title of E1:J1, I want to output whats in my next tab appropriately. Unfortunately that next tabs data dump does not have the dates in the same format, hence they...

Hello everyone my name is Arjen and I'm new here. I'm working with a set of data: A smaller example: Column A: Date Column B: Employee Column C: Revenue Now it's no big deal to figure out the revenue per employee and date. But the groups the employees belong to is not in the database and I...

Hi! This might be more of a math question but here goes: I have two different contract rates, $52.38 and $52.50. Each rate corresponds to a certain amount of revenue, lets say $30310 and $1253 respectively. What would be the weighted average of those two rates? I got 52.39 using sum...

I have found a lot of solutions for my problem, the strange thing is that when I change the line it works but when I run it again it fails until I change the line again. If this makes no sense good because it doesn't make sense to me either. I have done this a million times and it has always...

I have a workbook (A) that contains multiple tabs, where each needs to be linked to an external workbook (B) that also contains the division revenue on multiple tabs (Dallas, Houston, etc). In workbook A, the user will select a division (Dallas for example), which will look up the corresponding...

Hello I have a series of rows that I need hidden on multiple tabs. It is a financial spreadsheet and below is an example of row columns. For simplicity sake is there a way I can hide using row names so every sheet hides the same rows? I need to hide about 10 rows on each page but they all...

Hi All, I have three table in my database 1) products with two columns - product, price 2) region with two columns - SalesPerson, Region 3) transactions with five columns - date, SalesPerson, Product, Discount, Units I want region wise net revenue. Calculation for revenue is ...

Im trying to use an IF(AND function for a set of data that ive attached a sample of below, basically what i need the function to reflect is: The expected revenue account codes (4 digits - highlighted top left) that agree with the predetermined acceptable journal entry numbers (5 digits -...