# Calculate Cumulative Percentage

Apr 18, 2009
Microsoft Excel - Book1___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutB5=

BCDEFGH5JanFebMarAprMayJunTotal6-3%-2%5%8%5%5%???Sheet1

I have this example above which i want to know what is the total % change from Jan to Jun. In the total column, the result i got is 19% using formula

=1*(1+B6)*(1+C6)*(1+D6)*(1+E6)*(1+F6)*(1+G6)-1.

Is there any other more simplified or better formula that can be used actually?

View 9 Replies
ADVERTISEMENT
Jan 5, 2008

Cells D 5 to D 36 are representing day 1 to day 31 of the month. clocked working hours of the employees will be entered to these cells. they are supposed to meet the target of 8 hours clocked at the end of each working day. that means on day 1 the target is 8 hours, day 2 it is 16 hours, day 3, it is 24 hours. i want to see the cumulative progress in ( percentage) on any give day. That means on each day the clocked hours should be compared with the actual cumulative target until that day.

View 4 Replies
View Related
Feb 19, 2008

I have a table representing the usage of several thousand product in a market. Each row represents a product and one column indicates the frequency of use. I'd like to find out how many products represent the Nth percentage of the whole, when ranked from most used to least.

Shorter, if I want to know the Top 25%, how many products equate to the top 25% of all product frequency? ....

View 9 Replies
View Related
May 21, 2014

I have data of supplier spend and need to find percent of suppliers having top 80% spend.

How to get the cumulative spend within the pivot table itself. I can do it outside the table by calculations, but how to get the results directly using pivot table, because i am using that data in a KPI metric and a dashboard.

if not possible in pivot table, can i get it in a single step process using percentrank or percentile formula or anything else?

View 6 Replies
View Related
Apr 23, 2008

I have a dataset in Excel 2007 where I need to determine the number of census tracts (as rows) it takes for each column of data values (populations of different ethnic groups) to reach a cumulative percentage of 50% of their City group total. This is a measure of concentration that will vary from group to group.

I can do this manually by sorting each column from largest population percentage to smallest population percentage, then shift-click selecting the first row, scrolling down until I see the sum of percentages shown in the bottom right corner first reaches 50.000% or more.

Is there a cell formula I can use to determine the number of rows it takes to meet the criteria? I have to do this for 250 columns.

Is there a cell formula I can use to determine the number of rows it takes for a column of data values to reach a specific amount, that is first reach a cumulative percentage of 50.000% of the column total? It must be based on the data values from largest to smallest but I don't want to have to manually sort each column I have.

View 14 Replies
View Related
Sep 30, 2008

I have two rows one with the nr of weeks and another with revenues like that:....

i need to calculate the cumulative sum without inserting another row in the week that i define like an input so it could be changed.. for example the *** sum in the week 5 shloud be 900.

View 3 Replies
View Related
Jul 28, 2014

calculate the running total of time spent in the attached spreadsheet.

View 8 Replies
View Related
Jun 7, 2014

I receive monthly expenditure returns from different departments which I have to consolidate. The problem I'm encountering is that some departments submit their data as a monthly figure and some as the cumulative position. It would be useful if I had a formula that identified what data type was submitted and from that calculate both the monthly and cumulative figure.

If you look at the attached example I'd like to input a formula in columns I and J that uses the data contained in columns B to E to calculate the monthly and cumulative expenditure figures.

View 2 Replies
View Related
Apr 26, 2013

calculating the percentage of a percentage and writing the formula for excel.

There are 295 people in a room, of the 295, 75 or 25% are mothers. (I know how to calculate 25% - 75/295 = 25.42) of the 75 mothers 35 have 3 children, 32 have 2 children and 10 have 1 child.

35 is what percent of 25%

32 is what percent of 25%

10 is what percent of 25%

View 3 Replies
View Related
Jan 28, 2009

I need a formula to calculate the amount due based on cumulative sales once a breakpoint amount is reached.

Example:

Breakpoint:

cum sales are > 500 pay at 3%

cum sales are >1,000 pay at 2%

month/ sales/ cumul sales/ amount due

jan/ 100.00/ 100.00/ 0

feb/ 600.00/ 700.00/ 6.00

mar/ 600.00/ 1,300.00/ 18.00

and so on...until the end of year.

I tried using an if formula by could not get it to work.

View 9 Replies
View Related
Jun 21, 2014

I have a simple issue i cannot figure out how to write a formula for.

In A2 i have the number of operations.

In A4 i have the percentage of CPU usage it requires to complete those operations.

I need an output somewhere that will tell me how may operations I can get per 0.1% of CPU usage.

View 5 Replies
View Related
Jan 26, 2009

I have attached a file with both a sample section of data on the first sheet and the outcome I would like on the second sheet... I would do it all manually but there are over 200,000 rows in the actual file.

The macro needs to calculate the percentage of sale for each reference number within each part number and move down to the next part number and do the same until it reaches the bottom.

View 9 Replies
View Related
Jun 14, 2007

code needed to be able to automatically calculate the percentage needed from one year to the next. I simply need it to automatically create a third column each time the copy old data button is pressed, and I need the column to have the percent increase ((current year - past year)/current year). Hopefully you can understand what I am aiming for. I have the current code below, and I will attach a compressed and stripped version of my workbook.

View 13 Replies
View Related
May 18, 2009

In the attched sheet, I am wanting to draw data from the worksheet "On-Off" Array $AI$14:$AJ$91 into column AA, while at the same time choosing the closest match to the time. I have managed to get the closest matching time into column AC.

What I am having trouble with is now calculating the number of staff on that break time (column Z) against the number of staff rostered on at that stage "On-Off" (column AJ). I thought it would be a simple division and format as a percentage, however something in it using the extract from the "On-Off" sheet is stopping me, and I cannot figure it out.

View 2 Replies
View Related
Nov 16, 2005

I have a row of numbers from 1 to 26 in cells A1 to Z1 representing numbers

'chosen' at random by 500 unique people.

I have another row of numbers representing the 'frequency' that the

aforementioned number was chosen in cells A2 to Z2.

Example:

1 2 3 4 5 6 7 8 9 10 11 ...

10 4 16 9 23 20 61 13 18 43 17 ...

Is there a formula that I could use to calculate the percentage (0%-100%)

that each number was chosen?

View 14 Replies
View Related
Apr 5, 2012

I have a column of percentages, how do I get an average % rate at the end of my column?

View 7 Replies
View Related
Dec 20, 2013

I need a correct formula to calculate percentage...mine is not correct

Cell J18 will hold the formula.Range C18:I18 will have values.

C18 will have a value for today,D18 will get a value tomorrow,E18 will get a value 1 day after tomorrow etc..etc..

J18 formula - =sum(C18:I18)/7

If I only has a value in J18 then it will divide that single number by 7.......can a formula only divide by entries in cells....if I have 1 entry then it divides by 1,if I have 4 entries then it divides by 4 etc..etc until thee is 7 entries.

View 4 Replies
View Related
Nov 14, 2009

What I have is four columns with data. First column name second column number third column name fourth a number. Trying to get the total of the numbers for the names. So the first and third columns have names in them and they can be in each column or just once in either. I need to get a total column with all the unique names and then their corresponding number (added together if they are in both columns) to display the name and total. The names could be duplicated in each column as we (hopefully) have a lot of the same people coming week in week out.

What it is being used for is a two week and four week revolving attendance. I have a daily sheet one that I am using data filter unique values and then a countif to show me their attendance for the week. Putting it into a totals page sheet with week 1 week 2 etc.

So looking for a way to get all the unique names and their corrorsponding cell value added together to show the persons attendance for two weeks and then the month.

View 9 Replies
View Related
Oct 27, 2006

how to display a percentage in a field in excel.

EG.

If I have a calculated price in cell A and I would like to enter a price manualy in cell B , how would I get excel to display in another cell what perecentage A is of B

price A would would be for example a purchase price , Price B would be a suggested retail price entered manualy and i would want cell C to show me what percentage increase it is of price A

View 4 Replies
View Related
Nov 15, 2006

I have in row D a list of numbers and in cell F a list of salaries. I need a forumla to tell me what percentage D1 is of F1 etc.

IE the formula will be something along the lines of D1 * 12 / F1 * 100

View 5 Replies
View Related
Jun 26, 2007

in A1 I have 57 in B1 I have 75 so if I calculate percentage between those two I should get somewhere around 5% instead I'm getting 76%,

what am I doing wrong, in C1 I have =A1/B1 and then formated under percentage.

View 6 Replies
View Related
Oct 18, 2007

In my spreadsheet (testing.xls) I have a chart to mark the quality of a phone call based on a list of 8elements being judged. I have a likert scale for the quality result for each element, say for example 5 for highest, 3 for average, 1 for the poor, 0 for very poor and NA for an element which is not counted.

At the bottom of my table I have a cell where it would work out the % based on the outcome of the result from the different cells being ticked, what would i need to do to have excel work this out for me? Please bare in mind that if there is for example 1 element out of the 8 elements marked as NA the result would be divided 7 instead of 8.

View 9 Replies
View Related
Apr 15, 2008

I am trying to create a simple formula to extract cost from a total that includes both cost and and a percentage for maintanance. Assume $100, 10% of which is maintenance the remainder is cost. If I just subtract 10% from $100 I get $90, however 10% of $90 is $9 which equals $99.

View 8 Replies
View Related
Jan 22, 2014

I have a pivot table that analyzes test results. Assume three fields: Test, Result and Failure. If a test resulted in a failure then there is 1 in this field; otherwise there is a 0. There are several test results for each test. I want to calulate the percentage of failures for each test. I have selected Test for Row Labels. I cannot figure out how to calulate the percentage. Basically, the formula equates to =SUM(Failures)/COUNTA(Test). In other words, for each test add the failures and divide by the total number of results for that test.

View 2 Replies
View Related
Jun 26, 2009

I'm trying to do a forecast of my organization's budget for the next five years and need to create scenarios where certain figures will either be increased or decreased by a specified percentage that varies from 5% to 20%. I have recorded eight macros that can accomplish this task, but I feel like there must be a more effienct method.

In addition, I would like to increase or decrease the figures from either column H or column J. Column R is the results column. This is the macro I recorded that provides for a 10% decrease:

View 5 Replies
View Related
Aug 10, 2005

example 1:

This years sales are $3700, a decrease of 11.6%. What would last years

sales be?

example 2:

This years sales are $4500, an increase of 151%. What would last years

sales be?

View 12 Replies
View Related
Jul 17, 2008

I am working on a spreadsheet which has lots of data in it. I have a Column i.e. Checked out and on each cell entered an X Mark indicating that a device has been checked out.

Since this Checked Out Column goes all the way down to > 1000 cells. Is there a way for us to make a formula and calculate percentage based on the number of X's that are entered and tell as that out of 1000 cells, the X's are 65% and so the blank cells would have to be checked to complete the list?

View 11 Replies
View Related
Jul 6, 2012

I have a pivot table in which 50 rows data and each row contains in the end %age. End of report i get grand total but it sums the percentage column. I need to calculate percentage in the end of grand total. How can i get it.

View 3 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
Jan 16, 2014

I have a list of group ID codes, which contain 1 or more product codes within them.

Some product codes contain an "alternative" value (the actual value is irrelevant) and others do not. See example below

Group ID

Product Code

Alternative

56381

240027

160380

[Code] .....

Ultimately what I need to achieve is a percentage of how many product codes, within each group ID, contain an alternative.

So for the example above, group ID 56381 would have 50% codes with alternatives.

By counting the occurrences of a group ID and whether 1 particular code has an alternative I have calculated individual percentages against the size of the group e.g. product code 240027 (given a value of 1) divided by the total number of codes in the group (4), returns 0.25. Obviously doing this across the whole group would give my result (0.5 or 50%)

However some groups contain over 100 codes and the spreadsheet is 40K rows!

View 5 Replies
View Related
Feb 13, 2010

I am trying to calculate APR (Annual Percentage Rate) for a mortgage loan that has a balloon feature. I have tried to the the RATE function but it only gives me the APR for a loan that is ammortized over 30 yrs and paid in 30 years. I need the APR for a loan that is ammortized for 30 years with a baloon in 5 years.

View 9 Replies
View Related
Jul 29, 2006

I have events in column 1,in my sheet there are about 800 events.

In col 2. each contestant has a label,blue(b),green(g) or red(r)

In column 3 I want to print the % of blue + green of the total for each event,

e.g first event in attached sheet would show 77.7% down to row 10 in col 3 etc.

View 9 Replies
View Related
Jun 28, 2007

I am trying to find a formula to calculate the percentage of the positive numbers in a column. For example, if I have a column that has positive(green) numbers and negative(red) numbers in the cells to show over daily goal or under daily goal, and I want to at know what percentage of all the numbers are the positive ones.

View 3 Replies
View Related
Aug 9, 2007

I have a column that is a percentage(p%) which measures the fullness of the location(loc) that the item(ite) is in, which also has a corresponding location(loc) and item column(ite).

What I need to do is add as many items(ite) to one location(loc) as possible without exceeding 100%(p%), however if the value exceeds 100%(p%) then we need to start all over in a new location. The end result would be an unknown amount of unused locations.

If p% < 100 then add the next row's p% value, else start over with a new location. I am trying to add as many items to one location as possible, and once a location fills up, we will use the next one.

View 6 Replies
View Related
Aug 14, 2007

what I'm trying to do.

Background:

I play a game that requires 5 members to play, however you can have more then 5 members on the team. In order for a player to receive points for playing they must have played at least 30% of the total games played. The problem for me is when trying to figure out how many games someone needs to play to get to 30%, the total goes up as they play those games.

What I would like to accomplish:

I'm looking for help on a formula that would figure out how many games a player would need to play to get to 30%. I have a column that is total games played, %of games played by player, games played by player, and games needed to play to get to 30%. Basically the user would enter the # of games played by each player, and the total games played overall for the team for that week, the spreadsheet would then show the # of games each player that isn't above 30% would need to play.

I tried to make the question as clear as possible, if anyone needs clarification,

Originally Posted by shg

Welcome to Oz, Basca

spreadsheet with a representative sample of your data?

Games Played

Player 1 20

Player 2 7

Player 3 13

Player 4 20

Player 5 13

Player 6 13

Player 7 7

Player 8 7

Total Games Played20

View 9 Replies
View Related
Sep 11, 2007

I am having problems with a macro I wrote that basically fills things in two columns based on a set of values from other columns.

Lets say it looks like this (column B is based on column A):

A1 = Hi

A2 = Hello

A3 = Hi

A4 = Hello

A5 = Hi

A6 = Hello

A7 =

A8 = Hi

A9 = Hello

A10 = Bye

After the macro runs, column B should look like this:

B1 = 10%

B2 = 20%

B3 = 10%

B4 = 20%.............

View 9 Replies
View Related
Jan 24, 2008

I have two columns of data, in another column I have the difference between these two columns, now I want to show the difference as a percentage. Assume cell A is 0.02 and cell B is 0.03 the difference is 0.01 and the percentage of the difference would be 33% or 0.01/0.03, my problem is when cell A is 0.04 and cell B is 0.01 the same formula wouldn’t work in both cases since in the first A<B and the second A>B is there a way that I can take the difference and divide it by the greater of A and B without having to do it manually?

View 6 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
Aug 6, 2014

I am trying to do a spreadsheet that calculates the monthly rent from 9/1/14 through 1/1/15, then rent gets reduced from 2/15/14 through 1/1/16, then after that there will be an increase of 3% per year for each year until 8/2019.

View 1 Replies
View Related
Aug 24, 2014

If we have marks for students in some grade in all subjects, in each subject if we make the marks bounded in (50<, 50-59, 60-69,70-79,80-89 & 90-100).

How we can find the percentage for each boundary?

View 5 Replies
View Related