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.
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?
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).
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.
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%
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%.
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.
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.
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.
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.
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%?
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%.
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.
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.
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?
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.
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?
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)
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?
