Getting Percentage Of Attended Meetings
Mar 31, 2014
I am working on a spreadsheet to keep attendance at meetings. I have used "X" to mark someone present. I have calculated all of the "X's" to once column then I want to get a percentage of meetings they attend. Here is what I have:
=COUNTIF(A3:V3,"X") - This gives me the number of meetings attended there are a total of 21 scheduled.
=(X3/21)*100 - This should give me the percentage of meetings attended.
Problem is I get 476%, I know it will be something simple, just wanted to ensure the formulas were right and it should be something simple.
View 8 Replies
ADVERTISEMENT
Jan 5, 2009
I'm trying to figure out how to write a formula to add up hours that were attended for various individuals. My data is coming in from scanning their barcodes, so I'd rather not manually add their hours. I have these columns: Date, Time, First, Last, Member ID, CEU. My hope is that I can take the Member ID and write a formula that adds up the CEU column.
This issue I'm having is how to deal with the variables of someone only attending two sessions, while another attends four? I'm not sure how to do this so I'm seeing if anyone knows if this can this be done?
View 9 Replies
View Related
Apr 30, 2014
How to use conditional formatting in Excel 2007 (). I'm creating a spreadsheet to track my group's timeline for completing strategy meetings with our customers. When we have a meeting, I will enter the date of that meeting in a specific cell. In a successive column(s), I'd like for a cell(s) to turn a specific color based on the length of time from the last meeting (or if there is no date for a meeting entered - i.e. no initial meeting has been set).
View 9 Replies
View Related
Apr 3, 2013
I have a workbook that I've built for a project. I've attached a sample workbook. What I'm trying to do, for the entire sheet or workbook if possible, is turn any Cell with a percentage of 30% to 49% yellow and any cell with a percentage of 50% or more Red. I would also like to move the ID's of the variable cells, for example Id number 9922, to the cells beside the description of the rows, Affected would be an example, if the information contained in the same row as the ID meets with a set of variables.
For example I only want the ID's moved if they correspond with IDsub 1-25. One more thing, the people who will be using this spreadsheet will be copying data from a website when it is imported it does not insert the values as numbers. I would like to format the cells, in example workbook they would be any of the cells labeled ID IDsub Variable or Number, so that anything put in that cell will automatically be converted to a number.
I should also probably add that the formatting will be done on approximately 80 rows a sheet with 47 sheets.
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
May 26, 2014
How can I toggle between percentage and actual value to display on a pie chart?
View 1 Replies
View Related
Apr 8, 2014
I have a whole number (207) in B5. This should be seen as a percentage (207%).
I want to add this percentage to the value in M15, which is not a percent (2705.8).
I would like to display this sum in M17.
The number that is displaying now, after simply putting 207% (I don't want the % symbol in there) in B5, and the formula =sum(M17,B5) in M17 is 270787%.
This is obviously not correct.
View 3 Replies
View Related
May 5, 2014
Why is Excel not rounding up a percentage of 93.5 to 94?
View 6 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
Dec 16, 2013
The cell I am referencing value is 100,000
I need to take two percentages off of that number. First 50%, then 37% and have the value in a SINGLE cell.
Because 100,000/1.87 is not the same thing....of course.
View 11 Replies
View Related
Mar 6, 2008
Is there a formula that I may use to keep track of the YTD percentage of attendance of volunteer workers over the course of a year? I have approx 200 workers meeting once a week. Their names are listed in column "A" from A-4 to A-204. Starting in column "E" is the date of the weekday for attendance.
For Example: E-1 is dated Jan. 7, 2008. F-1 is dated Jan. 14, 08 etc. I place a one (1) in the corresponding cell to show that they attended. The formula I need would start in cell D-4 and be dragged down to D-204.
There also must be a way to factor in the weeks which we are to meet that must be cancelled due to weather etc. The worker should not be penalized due to our cancellation.
View 11 Replies
View Related
Nov 25, 2008
I was wondering what the formulas was for adding 20 percent to a price of lets say 10.00. What would I use for this?
View 2 Replies
View Related
May 13, 2009
I've seen a few finance excel sheets lately (don't have an example right now... ) that have a total number for something and then in parentheses next to it a percentage of the total is automatically calculated. So I have 5 pens and that's 10% of what I have in my pencil cup --> 5 (10%) is how it is displayed.
View 3 Replies
View Related
Sep 17, 2009
I would like to know whether it's possible to evaluate the percentage of a text value ie 'Approved', after filters on other columns have been done.
AREA YR DECISION
HN 09 APPROVED
NYM 08 REFUSED
RC 09 APPROVED
HN 09
RC 08 REFUSED
? %
So if I filter by AREA and/or YR, I would like the % of how many were 'Approved' in that filtered range (ignoring any blank cells in the DECISION column).
So far I have a basic
=TEXT(COUNTIF(C2:C6,"*Approved*")/ROWS(C2:C6),"0% ""Approval Rate""")
but it doesn't work once I filter by AREA or YR, and doesn't ignore blanks.
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
Aug 23, 2009
I've been trying to set the scroll bar min/max/small change to a decimal (percentage value) within the properties, obviously this does not work.
Since users can enter a value in the link cell for the scroll bar, how can I modify the current min/max/small change via macros so the scroll bar will show a min on 1%, small change of 0.25% and max of 25%?
View 14 Replies
View Related
Feb 18, 2006
I m having several problems and we will start with this one first. OK, we run machines for an 8 hour shift and these machines are down or not running for a few hours out of the 8 hour shift. I want to be able to put a number in a cell called "Delay" lets say 4:00 hours to make it easy and in the next cell over called "%" I want it to give me the % that the machine wasnt running for the 8 hours. The answer is 50%.
View 9 Replies
View Related
Feb 17, 2009
i have for example column I, J & K. col I and J has both negative & positive values and K (I/J) works out the %
Col I Col J col K
135975 583333 23%
-27748 583333 -5%
-18186 583333 -3%
272550 583333 65%
But i need a formula or formatting that always shows the negative percentage as a zero.
View 2 Replies
View Related
May 7, 2009
I have a simple spread sheet where i need a formula to work out a percentage. eg total cases 35246 number of errors 3. what percentage is the 3 of the total cases and what is the formula required to reflect the answer.
View 3 Replies
View Related
Jul 15, 2009
I have an issue new client is asking for me to present my reports with a percent complete. We do survey work and all our date is in Ft. The way my file is set up right now i have H5-H100 as incomplete footage, Column I5-I100 has my completed footage and to keep it simple Row 13 A-k show total amount of footage. He wants to see everyday when i submit the % complete based of footage incomplete and footage completed.
Anyone able to help me out with a formula for this? I tried messing with it a little, wasn't really able to get it down and my Excel skills definitely aren't past beginner level.
View 6 Replies
View Related
Aug 16, 2012
=IF(AE6="","",LOOKUP(AE6,{0,0.8,0.9},{"Failed SLA","Borderline SLA","Passed SLA"}))
The above formulae I have works but this changes this to failed when a 0 is shown in the field.
This 0 is shown in the field this is due to the item having no data how can I cahnge the formulae so the cell stays blank
View 6 Replies
View Related
May 30, 2013
I have 31 cells in a row (one for each day of the month. we collect data in these cells by typing "y" or "N". based on these input, cell 32 calculates the percentages based on total of Y's. Cell 33 has goal percentage. So, if the goal percentage is 30, Is there a way when a "y" or "n" is entered in cell 25, if the data percentage is = or 5% above the goal to get text message saying "good" but if the data percentage is 5% or more below goal, get a "not good" message?
View 3 Replies
View Related
Sep 5, 2013
I have a sheet comprising of 4 columns, laid out like the below ;
A4 = Equipment
C4 = Cost
E4 = Revenue
G4 = Gross Profit
I require to enter a percentage into the gross profit column, and for this to interact with the cost column, then for the revenue column to return the total of the cost including the profit.
View 3 Replies
View Related
Apr 9, 2014
I have a table where a field is called "Expected conversions at [X%]".
X% is a monthly calculation.
So to populate the table row name I tried ="Expected Conversions At"&" "&C28 where C28 refers to a percentage calculated elsewhere in the sheet.
Cell C28 is formated to 1 decimal place. But when I refer to it in this manner it displays to many decimal places.
The result:
Expected Conversions At X.XXXXXXXXXXX
It should say:
Expected Conversions At X.X%
How do I do this so as the % is dynamic and auto updates each month?
View 2 Replies
View Related
Mar 26, 2008
how to construct a formula that would give the amount of deposit needed initially that would equal, after an immediate percentage reduction, a certain amount.
For example, if the initial deposit was immediately decreased by 2.9 percent and 30 cents (as in a PayPal transaction), what would that initial deposit have to be to equal exactly 50 dollars after being reduced?
View 9 Replies
View Related
Apr 23, 2008
I have the following cells:
A1: the percentage difference between cost1(D1) and cost2(C1)
B1: total product cost (C1+D1)
I need a formula that no matter if the %diff increases or decreases this would reflect in C1 and D1 (so basically C1+D1 would always add to B1 but with the split of % in A1)
View 9 Replies
View Related
Jun 25, 2008
I have two rows of data representing marks out of different amounts.
E.g.
A1=23, A2=14, A3=50 etc.
B1=12, B2=10, B3=32 etc.
So, the first mark is 12 out of 23, the second is 10 out of 14 and so on. I have a large number of these for at least 250 people. Is there a simple formula that will immediately work out the average percentage for all of the marks above? If so, will it still work if some marks are missing?
View 9 Replies
View Related
Jul 7, 2008
Store A sells something for 100
Store B sells the same item for 125
Store B is 25% higher than A
how would a formula be written to show that?
Store B / Store A = 1.25 How do I get it to 25%
View 9 Replies
View Related
Jul 29, 2008
I have a parts list that works fine, and it works out a margin % of the cost and retail prices
the formual is
=IF(ISERROR(O18/N18),"",O18/N18)
now i would like this to show 0% if cell F17:F517 shows either "surcharge" or "consumables"
Its a bit weird i know but thats how i need it to work
Dont know if this formula helps in anyway
=SUMPRODUCT(--ISNUMBER(SEARCH(" Surcharge "," "&F17:F517&" ")),G17:G517)
View 9 Replies
View Related
May 10, 2006
I'm creating a spreadsheet were I need to take away time from each other to get a percentage for example
10:00:00 (A1)
take away 01:00:00 (B2)
Would give a percentage of 90% overall. But if I use the formula A1-B2 I get the answer 37.50%
View 5 Replies
View Related
