# Calculate The Total Revenue

Feb 6, 2010
I have a table which shows the monthly revenue of Company ABC , by client / by location / by business line.

ClientCountryBusiness LineJan-10 Feb-10Mar-10A001SingaporeResidential$ 50,000.00 $ 23,333.00 $ 54,115.00 D003SingaporeRetail$ 50,000.00 $ 21,548.00 $ 54,654.00A001SingaporeCommercial$ 63,321.00 $ 75,542.00 $ 21,564.00 D003AustraliaResidential$ 26,564.00 $ 50,000.00 $ 45,654.00 G002AustraliaRetail$ 50,000.00 $ 21,546.00$ 63,321.00G002AustraliaCommercial$ 26,602.00 $ 65,341.00 $ 24,568.00 A001Hong KongResidential$ 33,565.00 $ 26,564.00 $ 64,454.00 G002Hong KongRetail$ 54,232.00 $ 50,000.00 $ 15,454.00 D003Hong KongCommercial$ 26,564.00 $ 21,564.00 $ 23,333.00

If I want to calculate the total revenue for the month of January based on the following variable criteria:

Criteria

Client: A001

Country: Singapore

Month: Jan-10

I can achieve that with the use of SUMPRODUCT. However next month, I will then have to manually change the SUMPRODUCT formula so that it will extract data from the Feb column instead of the Jan column.

Is there a formula which will not require me to change the formula every mth? Ie. I can get my answer simply by changing the criteria?

View 9 Replies
ADVERTISEMENT
Aug 5, 2014

Pivot_example.jpg

Regarding the attached pivot table screen shot, I would like to be able to add total revenue and cost for each product and overall to this pivot table. IOW, instead of just showing the net amount of 3,200 for all blenders, I would like it to show Revenue of 12,500, Cost of (9,300), and the net amount of 3,200 for all blenders (i.e., for Boise and Chicago combined), in addition to the totals for each of the two plants. Also would like to see total revenue, cost, and net for all products and plants combined at the bottom. Can this be done?

View 4 Replies
View Related
May 5, 2014

i wish to do some conditional formatting. my target for the first 6 months from date activated is 50,000 after 6 months is 100,000. and for those below target, i will need it to be highlighted in red. thus i have 2 sets of conditions.(calculate the no. of months and the revenue).

View 2 Replies
View Related
Mar 5, 2014

I need to set up an easy to use spread sheet for my office. It needs to be able to calculate the running total spent of fuel, as well as include any discounts we get and then calculate our total savings.So basically, total spent and total saved.

View 3 Replies
View Related
Aug 13, 2009

I need a formula that will calculate the total of the items in column "W" when the row directly below it contains a "1" in column "V". It will need to calculate the totals from that row all the way up to the next row that contains a "1" in column V.

Example:

In X14 (where I will put the formula) it would total W9 through W14. However the formula still needs to be able to calculate the total if there are more or less cells to sum. So that the same formula could calculate that in X8 it will total W5 through W8.

View 14 Replies
View Related
Jan 13, 2014

I am preparing a daily report available in sheet1 with the actual input in sheet2 generated through a tool.

The report contain three columns i.e. total cases, Total correction done and Not corrected. From the total cases on a specific date, I need to calculate how many correction have been done and how many are pending.

E.g. 01 January 2013=5 cases are uploaded in the tool.

on 02 January 2013, it was observed that 3 cases were corrected and 2 are pending But 9 cases cases are uploaded on the same day in the tool .

So Total correction done (C3)=3

Not corrected(D3)= 11

View 2 Replies
View Related
Oct 27, 2009

I have a list that is numbered 1 2 3...ect. I want to have a cell that tells me the total number of entries. I have a I'm not sure how I could do this.

1

2

3

4

5

6

1

2

3

Total = ?

If I do a normal sum it would just give me all of those numbers added up. I want the total to read 9 (in this case) My list changes all the time so I want that total to tell me how many entries I have.

View 3 Replies
View Related
Mar 5, 2014

I am creating an employee database. Any simple method for recording then calculating a total of occurrences when someone is tardy. I thought of using an OptionButton but I don't know how it could be applied and stored in my database. This is the code for the form as it exists now:

[Code] .....

View 1 Replies
View Related
Apr 5, 2007

I've got an excel spreadsheet that is using imported figures from another source. I'm just trying to create a macro that will locate the last cell in Column N, Then will total all the cells above it. I've got the below code to select the last cell in Column N.

myrow = Range("N1:N" & Range("N65536").End(xlUp).Row).Count

For i = 2 To myrow

Range("N" & i).Select

But I can't figure out how to do the sum part. I've tried to record a macro but to no avail. Since the number of rows will change each day, I need to somehow catch the range. This is part of a bigger project, but if I can get this part working, I think I'll be home free. Attached is a small example.

View 6 Replies
View Related
Oct 18, 2006

Basically, I'm trying to have a cell (eg.A1) where i can input a dollar value and when enter is pressed, on another cell (eg.A2) the dollar value gets added, then the original cell (A1) is cleared for the next input.

Then when I put the next input (A1) I want it to add on to this running dollar total (A2) and yet again A1 is cleared for the next input.

In addition to this I require an additional cell (eg.A3) that when each time a value is added in A1 it counts the times this is done.

View 9 Replies
View Related
Dec 4, 2013

I am working on an excelsheet containing a data dump from a manufacturing database. Inside this sheet i want to make subtotals of different production runs. The data that needs to be added up is in one big list between every production run there is an empty cel. So I want to make a formula that does: =SUM(one-cel-above-current:next-empty-cell-above)

View 6 Replies
View Related
Apr 1, 2014

How do you calculate the total commission of a particular person on a consecutive months ?

Attached is the excel file for reference : Total Commsn.xlsâ€Ž

View 1 Replies
View Related
Sep 30, 2009

In the file I have attached, I need to work out how to give the final total (cell G27) inclusive of VAT, dependent on the value assigned in cells K17-K26, which are explained in the list starting cell B29.

At the moment the value given is net of VAT, and I need the total figure in G27 to recognise that the first item needs to be at 15%, the second at 5% and the 3rd at 0%.

View 13 Replies
View Related
Oct 18, 2009

I cut alphabet letters out of MDF. I need to calculate the total weight of any letter.

I have a program that will give me the area of any shape. In the picture below I have started with the letter “A”. B7 is the over all area. D7 is the small triangle. G7 is the total area minus the triangle D7. H7 is the thickness and I7 is the total volume.

The weight of my MDF I have set at is 850kg cubic meter. That’s set in A3.

I need the total weight of the letter in J7 to be in grams.

The idea is, I put in the areas and set the thickness and it gives me the total weight.

View 9 Replies
View Related
Oct 16, 2008

In the attached sheet, I need to find all items in column D that start with "LAB". For those items, Multiply the corresponding values from column B x column E and return the sum of all to cell T1. Once the total is in cell T1, I need to then delete the values in column E for those items (or change them to zero). I dont even know where to start with this.

View 3 Replies
View Related
Feb 8, 2010

The code below basically adds addresses to both the page and the oracle backend. However I am trying to work out how to limit the number of addresses they can add to 100. Therefore is it possible via code to calculate If Me.finish.Value minus Me.start.Value is greater than 100 then stop the code?

View 4 Replies
View Related
Aug 13, 2012

Below is my data

Complexity Type

Name

1

2

3

4

5

6

7

Ali,Shaheen Sultan

8

34

34

6

0

0

0

Budati,Manoj Kumar

7

18

18

12

6

0

0

Based on above data if The Column heading is 1 then it needs to go to the below data and multiply by that value and at the end should give me the total for the person. note that the total time is captured in a different sheet.

Complexity

Times Complexity 1

1

1.00

2

1.41

3

2.03

4

2.92

5

3.19

6

4.10

7

4.65

View 6 Replies
View Related
Jun 10, 2013

Formula to calculate the YTD % ?

If A1= YTD 100% and B1, C1 ,D1 etc.. do represent the month of Jan, Feb, Mar...etc

What do I have to use for A1 to auto-cal Jan - Dec?

View 2 Replies
View Related
Nov 27, 2013

I have a form which captures below details.

Label 1 = Time when form initialized or opened

Label 2 = Running Time (Live Time)

Label 3 = Total Time (Label 2 - Label 1)

Now what I need is since Label 2 is live time which shows the running time, Label 3 displays the total time spent. I want to display total time as running time.

e.g.

Label 1 = 13:01:00

Label 2 = 13:05:10 (running time/live time) which will keep ticking

Label 3 = 00:04:10 (I want even this as running time which keep running when label 2 is running)

View 1 Replies
View Related
Oct 18, 2006

I'm trying to have a cell (eg.A1) where i can input a dollar value and when enter is pressed, on another cell (eg.A2) the dollar value gets added, then the original cell (A1) is cleared for the next input.

Then when I put the next input (A1) I want it to add on to this running dollar total (A2) and yet again A1 is cleared for the next input.

In addition to this I require an additional cell (eg.A3) that when each time a value is added in A1 it counts the times this is done.

View 9 Replies
View Related
Aug 17, 2007

Is there a method to calculate the total number of hours in excel. In my attached file, the excel treat the 24 hours as time and recalculate from 0 hour.

View 2 Replies
View Related
Dec 12, 2007

Date Start End Total

12/8 - 2:00 3:00 = 1

12/8 - 4:00 5:00 = 2

12/8 - 20:00 21:00 = 5

12/9 - 23:00 0:00 = 3

12/9 - 3:00 4:00 = 4

=SUMIF($A:$A,">="&TODAY()-1,D:D)/24-SUMIF($A:$A,">"&TODAY(),D:D)/24

In the example above, E2 calculates the totals between 12/8 and 12/9 giving me 15:00. What I want the formula to exract is the total from Col D the total from 12/9 to the previous 24hrs.

12/8 has 2 entries, and 12/9 has 3 entries. The total I want to extract in 24 hours, NOT 1 day, is 14. What formula can I use that will calculate the totals in 24 hrs.

View 4 Replies
View Related
Dec 22, 2007

I have three values. The Quantity of items, the cost per items and the cost for the entire order. In some instances I want to give my clients items for free so I need to lower the cost per item in order to keep the entire order cost the same.

In order to ensure we are on the same page let's use the following associations:

Y = Quantity

X = Cost Per Item

Z = Order Total

So essentially I need a formula that will automatically calculate the cost per item (X) when more Quantity (Y) is added in order to keep the order total (Z) the same.

View 5 Replies
View Related
May 4, 2008

I have percentages set up for my monthly costs (student loans, food, spending money) and I want to be able to type in my weekly salary and have the percentages break it down into dollar amounts. Later, I'd like to put that into a pie chart, but I'm really only asking for help referring each category/percentage to the total $ value I enter each day/week/month.

View 4 Replies
View Related
Jun 27, 2008

I need a formula to calculate a total based on two conditions.

See spreadsheet attached.

View 7 Replies
View Related
Dec 14, 2013

Please refer to attached sheet.

I am using the attached to schedule the employees. All I want is a formula to add up all schedule hours per week per schedule in cell R2,R3 and R4.

Book2.xlsxâ€Ž

View 2 Replies
View Related
Dec 16, 2009

I have attached a sample workbook of what I am struggling with. It is for payroll, and I need to calculate taxes and pension as a percentage of Total W-2. The problem is that the 'Total W-2' column then deducts these taxes and pension.

Currently, the worksheet has about 30 columns out to the right using 'guesses' to back into these numbers, but I hope there is an easier way.

View 14 Replies
View Related
Dec 8, 2009

I would like to have something that looks like a running total, but isn't.

I have in a colomn 'rate' and after that a column for each month in a year.

I would like to have at the bottom a total cost, so rate x hours.

have a look at the picture.

is there a formula for this?

ratemayjunejuli

$10 2,02,01,0

$12 2,03,00,0

$10 3,02,05,0

$15 4,02,53,0

total cost $134,0 $113,5 $105

View 3 Replies
View Related
Dec 7, 2011

I have several columns of sub-total and total as shown in the screen print. I need some code that will allow me to take the value of total and subtract it from sub-total. The number of rows changes weekly so I cannot simply state =f10-f11

I thought xlup and offsetting would be a good way to do it, but I'd still need to assign a cell number.

View 1 Replies
View Related
Dec 2, 2013

My spreadsheet is set up so that Column A has dates and Column B has a value. How can I calculate the total number of values for each day of the week? I've tried a few formulas but they either didn't work or didn't actually take the value into consideration and just counted all the 'Mondays'. I'm not sure if that's clear enough, but if we're just looking at Mondays to simplify it:

Monday, 1 January 2000: 2

Monday, 8 January 2000: 5

Monday, 15 January 2000: 0

Mondays: 7

View 1 Replies
View Related
Jan 26, 2014

I am trying to keep a running total of cost, here is what I am doing

A B C D E F G H I

Date Books Pencils tax Month Books Pencils Tax Total

1/2/2014 11.50 2.50 .76 January 35.85 13.50 3.44 52.79

1/5/2014 14.50 3.85 .83 February 10.95 1.50 .68 13.13

1/6/2014 9.85 7.15 1.85

2/6/2014 10.95 1.50 .68

I only used Jan and Feb as an example. So as you see on the right side I will have all 12 months for the year and I just want all the totals for each month to auto calculate. I will have between 15 and 30 entries each month.

View 5 Replies
View Related
Oct 15, 2008

Having trouble adding a column of minutes and converting the total into hours and minutes. Say Cell A1 through Cell A18 each have 12 minutes in each cell. I want cell A19 to tell me how many hours and minutes of total time that have elapsed. I have tried hh:mm, [hh]:mm, but nothing works.

View 9 Replies
View Related
Dec 23, 2004

I want to calculate the total number of characters in a cell or group of cells. Also, as a second step, I want to indicate which cells have a total number of characters greater than a certain value.

View 9 Replies
View Related
Aug 4, 2013

I am trying to determine the total hours of downtime accumulated when there are 2 or more machines down during the same time period. To do this, I need to be able to determine if at any point there are 2 or more pieces of equipment down at the same time, and if this is true, how many hours were overlapped. The attached spreadsheet shows how the data is presented.

View 7 Replies
View Related
Feb 4, 2014

I have a base rate in A1, the the units in B1 and need a total in C1.

In A3 i have discount rate (%) for units between 0 and 9

In B3 the have the discount rate (%) for units from 9 to 15

In C3 the have the discount rate (%) for units from 9 to 15

In D3 the have the discount rate (%) for units above 16.

How would the formula looklike?

View 3 Replies
View Related
Aug 2, 2014

I have been playing around with some data and can't seem to get it the way I want it. I have played around with Pivot tables and grouping but I can't seem to figure out how to accomplish what I need in Excel. To better explain I have attached some test data of what I am trying to accomplish.

View 14 Replies
View Related
Jan 25, 2009

Need a formula to calculate a absolute total from a column of totals.

I thought this was simple, but the formula I made didn't work.

View 3 Replies
View Related
Dec 22, 2013

I am attempting to create a time chart that keep track how long a particular person works on an individual project to finally calculate profit & loss. Attached is the spreadsheet.

I am using invoice #'s to differentiate the jobs but have no clue how to make it calculate how much time was spent per job, per person then calculate the total cost per job per person?

sheets.time chart.xlsx

2014 tab- grey column is installer and white is shop employees

profit loss tab- all calculations done here

payroll tab- all cost data here

View 1 Replies
View Related
Sep 17, 2012

Any way to calculate the total hours staff work based on the mininum time of the first transaction to the maximum time of the transactions. I used a DMIN and DMAX function to get those times per employee. The issue is then the time goes over from one day to the next, such as from 11 PM to 4 AM the next day. As you can see in the data below,the fourth record shows the minimum time as 12 AM and the max as 11 PM with total time worked as 23 hours. In this example, the total hours worked should be five hours.

min time

max time

total hours

7:00 AM

16:00

9:00

[Code] .......

View 4 Replies
View Related
Jan 27, 2013

I use Windows Vista and Excel 2007.

So to cut to the chase :

On my spreadsheet, I have 6 main groups of columns, each one comprising 4 columns with their own automated calculations across the range.

Group 1: Cell H5, Cell I5, Cell J5, Cell K5

Group 2: Cell L5, Cell M5, Cell N5, Cell O5

Group 3: Cell P5, Cell Q5, Cell R5, Cell S5

Group 4: Cell T5, Cell U5, Cell V5, Cell W5

Group 5: Cell X5, Cell Y5, Cell Z5, Cell AA5

Group 6: Cell AB5, Cell AC5, Cell Ad5, Cell AE5

Then I have two columns following those: Col AG, Col AI

In each one of those two columns, I am trying to sum up a total value using The IF Function.

In Cell AG5 : the sum of the values of cells K5+O5+S5+W5+AA5+AE5,

ONLY IF the values of Cells H5, L5, P5, T5,X5, AB5 is equal to AG3 (which is a symbol (wingding 3 for capital P), this occurs 3 times out of 6, sometimes twice only, and at random, so I need the sum of 3 cells (or 2) out of 6, based on the above criteria.

Same in Cell AI5: sum of the values of cells K5+O5+S5+W5+AA5+AE5

ONLY IF the values of Cells H5, L5, P5, T5,X5, AB5 is equal to AI3 (which is a symbol (wingding 3 for capital L), this again occurs 3 times out of 6, sometimes twice and again at random, so again I need the sum of 3 cells (or 2) out of 6, based on the above criteria.

Using the formula: =IF(T5=AI3,(W5),0) , I retrieved the value of cell W5 into cell AI5; and when I tried the formula :

=IF(T5=AG3,(W5),0) , in cell AG5, it returned the value 0 which is correct again, as T5 was equal to AI3 but NOT to AG3.

But I cannot work out how to add all of the three values relating to each symbol, independently in each column, as they each occur randomly.

This is the way it looks in the spreadsheet:

Cell H5 Cell I5 Cell J5 Cell K5/ Cell L5 Cell M5 Cell N5 Cell O5/

Symbol (for P) Text Text Value /Symbol (for L) Text Text Value

And so on 4 more times across.

I could of course add it all manually for each line but I would rather have a formula to do it for me as all the other calculations are automated and/or conditionally formatted.

View 9 Replies
View Related