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
