Weighted Averages Using SUMIF And COUNTIF
DATA: D1:D11 contains either blank cells or a dollar figure from a payroll check.
E1:E11 contains either blank cells or the date of the check.
Current Situation: Using the following formula I obtain a weighted average of the pay checks, not including the largest. =(SUM(D1:D11)-MAX(D1:D11))/(COUNT(D1:D11)-1)
Problem:
I desire to calculate the weighted average based on the checks issued only prior to a certain date. I have used SUMIF() in other parts of the workbook successfully but needing to withold the largest value has presented me with a problem I can not find a solution to. =SUMIF((E1:E11,">="&TargetDate,D1:D11)-MAXIF(E1:E11,">="&TargetDate,D1:D11))/COUNTIF(E1:E11,">="&TargetDate,D1:D11)
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Calculate Weighted Averages Using High, Medium, Low
On another thread I found a solution to creating a weighted average given a pair of columns of numbers but I have column B consisting of values given as High, Medium and Low and the weighted column C of 1, 2 or 3. How can I use the formula below to accomplish this, or is this maybe not the right way to created a weighted average? =SUMPRODUCT(B2:B11,C2:C11)
View Replies!
View Related
SUMIF And COUNTIF
I want to calculate the average perofrmance % of 8 lines, the data isn't in one set of rows and some lines may not have values so I'm trying to account for this in my summary. The code I'm struggling with is this... =SUMIF(C5,C10,C15,C20,C25,C30,C35,C40,">0")/COUNTIF(C5,C10,C15,C20,C25,C30,C35,C40,">0")
View Replies!
View Related
COUNTIF And SUMIF Formula
It's been awhile since I've used excel formulas so I'm very rusty but I need to count the number of times I see a particular item in a list as long as it has another criteria as well. Example List and Result are below: I want to count the number of AAA Rewards that Alex has.... List #DateEmployeeAmountReward Type 14/17/07Alex$5.00AAA Reward 24/19/07Joe $10.00AAA Reward 34/19/07Alex $5.00 Store Certificate 44/20/07Alex $10.00 AAA Reward Result Employee # AAA Reward Amount # Store Certificates Amount Alex Brian Joe
View Replies!
View Related
SUMIF/COUNTIF With 2 Criteria
I am trying to extract some data from a large spreadsheet and having problems... Column C contains text descriptions, e.g 'Description One', 'Description Two', 'Description Three' Column O contains a date. I need to count the number of items that have a date prior to 1st April 2007 and have certain text contained in the full text string value in column C e.g. 'One'
View Replies!
View Related
SUMIF/COUNTIF = Average
I have a report that has thirteen tabs. Tab one is Jan; two, Feb; three, Mar, etc. The last tab is where I'm consolidating all the data into a report. In Row 2 of Jan-Dec are the days of the week. In Row 30 I have the data. I am figuring the average of each day of the week for each month as well as a total average year-to-date. Here is my formula for Jan and Feb: =SUMIF(JAN!$2:$2,"MON",JAN!$30:$30)/COUNTIF(JAN!$2:$2,"MON") =SUMIF(FEB!$2:$2,"MON",FEB!$30:$30)/COUNTIF(FEB!$2:$2,"MON") Works great after the month is over - but now I'm in March and the formula is adding all data form row 30 that falls under MON and dividing my all MONs even if it does not have data. How do I nest in the COUNTIF statement to only count MON IF there is data in row 30.
View Replies!
View Related
Count, Countif, Sumif
I've got a table that contains a lot of text that i need to summarse in another table. Its really just two columns the first contains a group name and the second a result. What I need to work out is the number of times the result occurs for each group. But every work sheet function I've entered fails.
View Replies!
View Related
Ignore Blanks Using =SUMIF/COUNTIF
I've come across a problem using the =SUMIF/COUNTIF function in excel. It incorrectly calculates blank cells as zeros. =SUMIF(D4:D54,"Solar",T4:T54)/COUNTIF(D4:D54,"Solar") The correct output should be 100%, but shows as 66.67% because of the blank cells in the column. How do I correct this?
View Replies!
View Related
Countif, Sumif Or Sum Product
I have a table with 3 columns, Project Person Hours A B 1 A C 2 A B 3 So on project A persion B has worked 4 hours. I seem to be able to use sumproduct for counting how many times the person is in the project but I cannot seem to add on the final hours part.
View Replies!
View Related
COUNTIF Or SUMIF: Changing Amount
I have a data range with 3 columns - A -employee number, B -charging number, and C -charge amount. "A" shows multiple times and must be associated with value from "B". I am looking for totals of "C" for any combination of "A" and "B". Ex. A B C 1 101 6 1 201 7 1 101 4 2 301 6 2 101 1 2 201 4 3 201 5 3 401 7 etc. I am looking for totals (from column C) for A and totals for A with defined B. e. g.: 1 for all 101 1 for all 201 1 total 2 for 201 etc..
View Replies!
View Related
How Do I Set Up A Countif Or Sumif That Is Multiconditional
I often try to set up a countif or a sum if that is conditional on two or more conditions. For instance - I have Radio stations listed in one column, flight dates in another column, number of contacts for each flight in another column and appointments created from those contacts and finally, revenue generated form those appointments. One example would be to sumif column one equals the radio station and column two equaled the flight date then give me the revenue.
View Replies!
View Related
Combine SUMPRODUCT, SUMIF, COUNTIF Within Date Range
The attached spreadsheet has a "master" workesheet in which I enter customer info, salesperson info, and date. The totals spreadsheet automatically calculates number of sales, contact value. I need to modify the following formulas to only calculate the data within a date range shown in 2 cells. =COUNTIF(Master!A1:A176,PayPeriod!A4) =SUMPRODUCT(--(Master!A1:A176=Totals!A4),(Master!K1:K176)) =E4SUMPRODUCT(--(Master!A1:A176=Totals!A4),(Master!K1:K176))
View Replies!
View Related
SUMIF/COUNTIF- Several Numbers That Are Contained In Non-adjacent Cells
I have several numbers that are contained in non-adjacent cells. I need to create a cell that will evaluate the cells individually to make sure that they are within a certain range. Once that is done, I want the remaining numbers that are within the range to be averaged. How the heck can I accomplish this task? SUMIF and COUNTIF will not allow me to use non-adjacent cell ranges.
View Replies!
View Related
Formula- To Pull Cell Values Similar To A SUMIF Function (SUMIF(range,criteria,sum_range))
I am trying to pull cell values similar to a SUMIF function (SUMIF(range,criteria,sum_range)). For example, in A1 I use a data list created from data elsewhere on the spreadsheet. In the data I created elsewhere, there are 2 columns being used. The 1st column is the information that is being used to create the list and the second column contains specific values (number or text). In the dropdown menu I select an available value (text or number) . When I have selected that value I would like cell A2 to show what the cell directly to the right of it shows from the data I have elsewhere in the spreadsheet as mentioned. I have tried the SUMIF function however it seems to exclude certain values (number or text) and I am not sure what else to use.
View Replies!
View Related
Nested SUMIF Statement Or Multiple SUMIF
I need to perform 2 SUMIF's on 2 columns of data to return a result and I'm not quite sure the best way of doing this. I'll give an example below. I have 2 columns of data, both numeric and the SUMIF needs to say if H1:H100="10" and also if J1:J100="907". I can perform one or the other but not both.
View Replies!
View Related
Averages From 2 Columns
We are trying to get an Average between 2 columns that have the same conditions. We have been using an array formula succesfully on data that is on 1 column and I have trying to incorporate an Offset into the formula with no luck. Here is our latetest attempt, WITHOUT THE OFFSET. The data is in Column P and Column N =AVERAGE(IF((('Mill Process Data'!N3:N6650,'Mill Process Data'!P3:P6650>.01)*('Mill Process Data'!N3:N6650,'Mill Process Data'!P3:P6650<.3))*(ISNUMBER('Mill Process Data'!N3:N6650,'Mill Process Data'!P3:P6650)),Mill Process Data'!N3:N6650,'Mill Process Data'!P3:P6650)))
View Replies!
View Related
Averages For Last 12 Entries
I need to calculate average for last 12 valid entries in a column. I say valid because if there are blanks or zeros in the cell they need to be discounted. The solution needs to work on percentages as well. To explain further Col A Col B Jan 2007 1 Feb 2007 5 Mar 2007 5 Apr 2007 0 May 2007 Jun 2007 20 Jul 2007 0 Aug 2007 Sep 2007 10 Oct 2007 0 Nov 2007 10 Dec 2007 18 Jan 2008 8 Feb 2008 6 Mar 2008 0 Apr 2008 May 2008 10 Jun 2008 1 The requirement would be to calculate average from Jun 2008 backwards for 12 months where there aren't zero or blank entries.
View Replies!
View Related
Automatic Averages
I am inputing each day the total amount of sales. I am manually doing the averages for past 12 weeks on Monday sheet. I would like when I enter the amount for that week that the cells B84, C84, E84, F84 are automatically updated for the past 12 weeks. I have tried a few different approaches but I keep getting #ref or circular reference
View Replies!
View Related
Rolling Averages
I am working on a spread sheet and am trying to use rolling averages of the last 3 months. I am using worksheets for each month with a final worksheet containing the 3 mo. rolling average. I tried using a formula with OFFSET and it worked fine if all the data was in 1 worksheet, but did not work for multiple worksheets averaging to another worksheet in the same workbook.
View Replies!
View Related
Averages Formula
In the following cells I have an average: B6,J6,R6,Z6, and AH6 and a total average on cell AP6 How would I go about making a formula for that. The reason why I ask is because all the info I have seen refers to the cells with the averages need to be in sequence or range and nothing about the cells being seperated. I also tried using the countif method, but same prob, the cells need to be within a horizontal or vertical range
View Replies!
View Related
Average From Several Averages
Column 1 contains the number of times an ad has shown Column 2 contains the average position of the ad from column 1 Like so, Ad Impressions.........................Avg Position Google: 14,220,023..........................3.2 Yahoo: 346,656...............................1.2 MSN: 123,234..................................8.9 Total: 14,689,913............................??? Doing the following, = Average(B2,B3,B4) This is not the real average as this is directly influenced by the number of ad impressions... How can i make a real calculation to give me the true total average position of my ads?
View Replies!
View Related
Working Out Averages
I havea list of values that I need to work averages out for. Unfortunately, sometimes the values will be a zero and these should be ignored. I can work out the averages easily enough using the average function, but can't quite figure out a way of ignoring the zeros. Sample data would be :- week 1 - 3.42 week 2 - 0 (zero) Using the standard average function, I get an average of 1.71 when I actually want it to have an average of 3.42. I would prefer a function for this but would settle for a macro even though it would increase the program run-time.
View Replies!
View Related
Splitting Averages...
If I have a varying number of figures(say between 4 and 10) which I want the average of the first half of the set and an average of the second half, is there a function which I can use to calculate this? ie if there is 8 numbers in total then I need the average of the first four and last four... but if there is ten figures total then I need the average of the first five and last five.
View Replies!
View Related
Weighted Average
I have a large dataset that includes information on the investment payout ratios of US companies over the period 2004-2006. I need to calculate the weighted average investment ratio for each company---see sample below Microsoft Excel - example.xls .... [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR. The corresponding weight for each year must be as follows: 0.5 for 2006, 0.3 for 2005 and 0.2 for 2004. Then, for company A, the weighted average will be: (0.5*B2)+(0.3*C2)+(0.1*D2) = 7.8 (see cell E2) The problem is that for some companies there are missing data for some years. For example, for company B, there are no data available for year 2004. In this case , the weights have to change to 0.6 for 2006 and 0.4 for 2005. Then, the weighted average investment for company B will be (0.6*B3)+(0.4*C3) = 16 (see cell E3). Similarly, in cases when there are data for only 1 year , the weight has to change to 1. Then, for company C the weighted average is 35 (see cell E4) Is there any formula to give me the weighted average as it appears in column E without having to adjust it for each single case?
View Replies!
View Related
Weighted Scoring
I'm doing a GCSE project for which I need a little help with Excel. I have a set of data about a persons monthly spending habits on Food 300 Entertainment 200 Clothing 100 Transport 260 The pre calculated budget allowance for the month was 500 I would like to write a formula that would do the following; give the person an score out of 1.1-10 based on how well he spent on the above items which are in order of priority (i.e. it is better to spend more on food than on entertainment etc) And then an over all score (1.1-10) that will reflect how well they spent.
View Replies!
View Related
Weighted Average ...
I have long lists of data which has name of manufacturer, number of items and fault rates of items. E.G Manufacturer.......Number of Items......Fault Rate Dell....................40000....................0.2% Dell....................42200....................0.4% Sharp.................303003..................0.1% Microsoft.............312340..................0.04% Dell....................3249321..................1% Panasonic............300020...................2% I need to find the weighted average of each manufacturers fault rate for just themselves, and also how the average of all the manufactueres would be if they weren't in it. So for example for Dell I would need their weighted average of their three data entries and also then the weighted average of Sharp, Microsoft, Panasonic together. I have been doing this by splitting the data into sections so for the example above I would do: Manufacturer.......Number of Items......Fault Rate Dell....................40000....................0.2% Dell....................42200....................0.4% Dell....................3249321..................1% Panasonic............300020...................2% Sharp.................303003..................0.1% Microsoft.............312340..................0.04% I would sum the Dell items, then sum the number of items excluding Dell then do two weighted average calculations giving me the ones that include then the ones that exclude Dell. Then I would do... Manufacturer.......Number of Items......Fault Rate Sharp.................303003..................0.1% Microsoft.............312340..................0.04% Dell....................3249321..................1% Dell....................40000....................0.2% Dell....................42200....................0.4% Panasonic............300020...................2% And do the same process but with Sharp totals etc then move onto the next one..... This example is with a very small data set so I'm sure you can see that this process is very time consuming, but I don't know any other way of doing it without splitting out the data first.
View Replies!
View Related
Averages By Week By Month
I have the following data by week: ------------------------------------------------------------------------ 29-Mar 5-Apr 12-Apr 19-Apr 26-Apr 3-May 10-May # of work days 4 4 4 4 5 5 5 Manpower 106 85 115 115 120 121 87 ------------------------------------------------------------------------ On a second tab, I want to show the data by month: ---------------------------------------------------------------- Apr May Jun # of workdays 21 (4+4+4+4+5) 21 20 Avg. manpower 108 104 .... ---------------------------------------------------------------
View Replies!
View Related
Averages - Specific Characters
I need a formula that determines the average of numbers based on specific cells. For instance: COLUMN A COLUMN B John Doe 1.48 Jane X 2.89 John Doe 1.89 Jane X 5.98 Michelle Doe 5 Claire Doe 3 Jane X 0 What formula can I use to give me the average of "Jane X" not taking into consideration the one with the 0 Value?
View Replies!
View Related
Calculating Averages In Spreadsheet
I'm trying to Calculte the Averages of just the Teachers Salaries in my spreadsheet. If possible i would like to put the average at the end of each of Teachers information. Is there code that would allow me to do so. I attached a sample file to view.
View Replies!
View Related
Variable Range Averages
I was able to record a macro that did essentially everything I wanted it to, with the important exception of getting the right selection for the average=() calculation. My worksheets are set up with multiple variable columns, and multiple data collection stations as rows. The rows are sorted by date, with a blank row dividing the data by month. There may be 50 rows in January, then a blank row, then 4 rows in February, then a blank, then 15 rows in March, etc. I can easily average the monthly values in, say, column N by typing "average(" in the cell where I want the average to be calculated, then selecting the top cell for the month of interest in column N, holding the shift key down, pressing end, pressing the down arrow, and then typing ")". The macro recorder, however, doesn't seem able to handle this method of selecting the cells to put inside the formula parentheses. If I try to run the created macro on other months, it will average the same number of cells targetted by the initial example (i.e. the month I was working with when recording the macro). Is there any way to code this operation so it will vary the number of cells averaged, based on the number of data rows present in each monthly group? My research into coding averages is turning up only examples that deal with whole columns or fixed cell ranges. Since I have a pretty big stack of worksheets to work though, it would be very nice to automate the process, but I'm still fumbling here. Not getting anywhere.
View Replies!
View Related
Averages With #N/A In Row/column
I am trying to work out the average volume of our daily downloads. I have used Vlookup to automate this. When there is no data it returns #N/A which is no problem. The problem arises when i try to work out the average for the month or peaks (MAX sum). I have tried several variations of sumif/if/isna etc etc and am not having much luck. Below is an example of what i am trying to average out: #N/A620#N/A That is 4 different days download data - I want it to ignore the 0's and #N/A and return the average for the days we actually had a download.
View Replies!
View Related
Getting Averages From Seperate Worksheets
The first one, I do i remove #DIV/0! from cell O7 in the worksheet "My overview"? The second one, I need to get averages of the QA score for the 3 months from January to March in the worksheet "My Overview" Cell E14 for the corresponding person on each sheet. I understand that there need to be values in place to get an average but is there a way to overcome this?
View Replies!
View Related
Top/Bottom X Averages
Have a five column worksheet with the column headings run column A1 - E1 and there are currently 112 players filling out the data with many more to come The 5 Column Headers are as follows: Player# ... PlayerName ... M/F ... SessionAve ... GamesPlayed What I need to do I pull out the top 5 male and top 5 female by SessionAve (including ties if possible). Would like the info to look like: Male Shooter ...Session Ave ...GamesPlayed Player1 .843% 30 Player2 .837% 35 Player3 .835% 25 etc.. Then Same for Female Players
View Replies!
View Related
Calculating Daily Averages
The data was taken in 15 min intervals and is organized by date. I have one column with the date and time and another column with the data. I need to find the average for each day. I have almost a years worth of data. Is there any formula I can enter to find the values in a given day and return the average of the values (without having to select the data for each day)? I want to be able to copy the formula down a column with the value per day.
View Replies!
View Related
Using Loops For Taking Averages
I have a column of 96 numbers (observations every 15 minutes for a 24 hour period), and I want to take the average of these numbers in groups of four (the hourly average). My data starts in cell A2 and goes to cell A97. My first batch of averages are labeled as follows: Range("A2").Select startCell = ActiveCell.AddressLocal ActiveCell.offset(3,0).select stopCell = ActiveCell.AddressLocal Now, clumsy programming aside, I just want to say something like this averageCell = AVERAGE(startCell:stopCell)
View Replies!
View Related
Histogram From Weighted Data
I'm trying to use the 2007 histogram tool (or frequency) to show me the frequency of data, but my data is in a different form than required for either of these tools. Let me use the following simple case -- to show the frequency of student grades both tools assume I have a list of student's test grades. What if I instead have more than one column, e.g., "grade" and "number students with that grade"?? My application is actually different, but it's still 2 columns, a numeric property and a weighting factor (e.g., fraction of the total).
View Replies!
View Related
Is This A Weighted Avg Formula
In Col DL are digits ranging from 1-36, in Col Dm are the number of times they were drawn in 36 draws. I have a weighted avg formula in Col DN, that I found thru search, but it doesn't appear to be working right or maybe I don't understand the formula. I have no idea if this can be done. ************************************************************************>Microsoft Excel - F5 HOT-COLD.xlsx___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)boutDN3DN4DN5DN6DN7=DLDMDNDO2DIGITSHITS 34125 47105 53395 62185 72885 DIGITS [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
View Replies!
View Related
Conditional Weighted Average
I have two columns. One has cost (column A) and the other has profit (column B). I'd like to calculate the percentage profit as a function of how much something cost. So, if it cost $100 and the profit was $20 I would like to calculate 20%. For all percentages, I'd like to average them. I understand this is a "weighted average" and was able to get this working with this formula:
View Replies!
View Related
Weighted Average With Grades.
I am having trouble coming up with a formula to calculate the weighted average of students Finals grades. This is the format my sheet is in to give u an idea. ----------------------------------------------------------------------- Test # 1 Test # 2Test #3Assignment #1Assignment #2Final Test Final MarkPossible Points:1001001001010100Percent Worth:20%20%20%5%5%30%Students:Anderson, Ken6473788768 ?Carter, Bill72768473.587 ?Dubeers, Ashley84887610590Jackson, Kevin7666549873Parker, Jerome82657679.560Remini, Leah969290101089Thompson, Chuck5042806.5760Vaughn, Sarah7265658970 ----------------------------------------------------------------------- - I have to come up with students averages based on the mark, the percent each grade is worth and the maximum amount of points its worth. Anyone know the formula or how to calculate the final grade using all of these factors?
View Replies!
View Related
Calculate Weighted Percentage
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 Replies!
View Related
Using Weighted Average In A What If Analysis
If I wanted to calculate weighted average of a bunch of salespeople, is there a way to not include some values, such as ones below a certain value? I'm trying to so something like, what would my weighted average be if I didn't include my bottom 2 salespeople or my top 2 salespeople.
View Replies!
View Related
Weighted Average In VBA
I have a spreadsheet which basically looks like this 2, 5, 15, 20 2, 8, 12, 13 2, 7, 19, 46 F, 1, 10, 26 P, 1, 10, 39 P, 6, 22, 89 P, 7, 14, 46 P, 2, 11, 14 ... Column A is the key. If multiple rows have the same key, they're related. The last column (DX on my spreadsheet) represents minutes participated, and is the weight variable. The middle columns are data that I'd like a weighted average for. Here is the output I'm looking for given the above example: 2, 6.66, 16.83, 79 F, 1, 10, 26 P, 4.91, 16.73, 188 Column A remains the same, with one row for each key. The middle columns have their weighted average (where 6.66 = (5*20+8*13+7*46)/(20+13+46)), and the final column (DX) is the sum of minutes for all like keys.
View Replies!
View Related
Weighted SUM By Criteria
I am trying to find a formula that will calculate a running total of employee time off. Time off is recorded in Excel spreadsheets that I created. V = vacation, S = sick, PD = personal day, and so on. For example: If a V is entered in any cell in their attendance worksheet, I would like for a 1 to display under the vacation total column. The next time a V is entered in, I would like it to update the cell containing the vacation days used for the year to 2. If a 1/2 V is entered, a .5 would be added to the total used.
View Replies!
View Related
Weighted Average Of Grades
I am in need of some more assistance regarding finding out a formula to find out the average grade of a pupil which ranges from letters 'A to E. This maybe be a simple task for experts, but unfortunatley spreadsheets are not my strong point. D7:D14 is the coloum that i wish to have an average of the grades acheived by each individual pupil in thier correspongin rows (on the right hand side of D7:D14) http://i41.photobucket.com/albums/e2...2/example2.jpg
View Replies!
View Related
Criteria Weighted Average
I have trouble finding the right formula for a weighted average price. The formula which i used in cell B2 of the attached file doesn't exclude irrelevant numbers. In the formula "= sumproduct(a5:a21;b5:b21)/sum(b5:b21)", i like to exclude cells B8, B9, B15, B19, B20 because the list prices are missing. How can i exclude these irrelevancies in the formula above?
View Replies!
View Related
Averages The Total Of Each Criteria For All The Paygrades
I have a spreadsheet with one "master" sheet and multiple "level" sheets. The workbook is an employee rating system and employees have different pay grades. The individual sheets represent each paygrade while the master sheet averages the total of each criteria for all the paygrades. Look at the image below: http://www.excelforum.com//attachmen...1&d=1165960332 What you see above is a cutout from one of the "level" sheets to give you an idea of how employees are added to the sheets. Sheets I have: Master/E1/E2/E3/E4/E5/E6/ The first catch is that the sheets will not have an equal number of "rated employees", so I would need to tell the program how to find the number of employees being rated (and how to reference the columns to find the total scores in). In the example you see name1 and name2... this represents 2 employees. To add another employee they duplicate the 3 rows and create another employee (i.e. name3). Second is that it has to disregard total scores that are "zeroes", meaning it does not average the total scores with a zero. The master sheet is just a duplicate of the "level sheets" but with 1 set of 3 row columns to average each criteria from the 6 "level" sheets. I appreciate your guys' help in advance. Thanks! - Kareem P.S. Those that are wondering, Total score = Weight(blue column) * points (1-10)
View Replies!
View Related
Averages From List Of Dates/currencies
I have a list of dates and the exchange rate at that time e.g.: 18/02/20051.449921/02/20051.451322/02/20051.441423/02/20051.444624/02/20051.4445525/02/20051.45228/02/20051.4508 What I need to insert are three formulas, 1 that works out the average for the last year, 1 for the year before that and 1 for between two given dates.
View Replies!
View Related
|
TRACKER
