# weighted average

1. ### Weighted Average for Non-Contiguous Data

Good Morning, I am trying to get a weighted average of data that is not contiguous I am using this formula: =SUMPRODUCT(BL117:BL134,BJ117:BJ134)/SUM(BJ117:BJ134) The data I need to be included in the formula is just the "ut" one, excluding the "m" ones. Columns are BJ, BK, BL and rows from 117...
2. ### Weighted salary by salary band

Hi I'd like to calculated the average salary for employees based on salary bands. The table below shows salary bands and the number of employees in each band. What's the best way of working out the average salary by salary band? I thought about taking the mid-point of the range then...
3. ### Weighted Average based on Field identifier

Hey Guys, How would I create a measure of a weighted average based on 2 different field values? I know how to do this in excel using SUMPRODUCT, but I'm relatively new to DAX and dont know how to do the same calculation that I would normally use in Excel. For the below, in excel, I would use...
4. ### Weighted Average / IF statement

Hi all, Any help would be appreciated. I am trying to create a way to model some data in Excel. This involves taking three sections (lets call them a,b,c) and their sub-sections (lets call them A1, A2, A3, A4, B1, B2, B3, B4, B5, C1, C2, C3) and adds individual confidence ratings to these sub...
5. ### Automated Autosum

Hi I would like to seek some advice on how I can do the following. I have a macro(I use a do while loop to check and insert the extra row) that sorts out data in a certain format by inserting a line(row) in between 2 rows effectively separating the data set. After running my macro, I am...
6. ### Conditional Weighted Average using same Data Column

Hello! I try to do a weighted average of data in a single column. Example: <tbody> Module Indicator Type Data M1 Ind 1 A 100 M1 Ind 1 B 80 M1 Ind 2 A 15 M1 Ind 2 B 20 Mn Ind n X </tbody> Simply put, I need to do weighted average per Type for Indicator 2 using Indicator 1. The...
7. L

### Weighted Averages Updating Through The Day

I want to calculate the weighted average of a set of data. At the end of each time block a value will be entered. The time blocks are all worth different amounts with Time A being 2.5 hours, Time B is 3.5 hours and Time C is 3 hours. I want the average to include a cell containing 0. I want the...
8. ### Create new worksheet every time new user enter the excel, taking averages of cells from all worksheet to a main worksheet

Hello all I'm very very new to VBA. I checked internet forums to find a similar case and tried to modify the program as per my needs but I'm not satisfied with my work. I need your support to do this. My case: I have a matrix 21 rows * 30 columns with drop-down list on all the cells, user...
9. ### Weighted Average with sumif

Hi I would like get weighted average margin by category. I want to use the sales to weight the margins. Any help? thanking in advance <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Invoice Number Product Sales Margin 2 22 Pen 110 15% 3 28 Books 200 11% 4 26...
10. ### Conditional Weighted Averages of Athlete Performances

Hello everyone, I need to report weighted averages of athletes' performances based on when they played, who they played against, and their positions. Here is an example to clarify: Let's say I'm looking at Team A. I want to know how all of the players in Position X who have played against...
11. ### Calculated Field involving the Total

Hi, I need help to create a measure for Weighted % of Active employees by agency. My logic is : Weighted % of Active Employees = (Active Per Agency/Total Actives All Agency) * (Total Per Agency/Total All Agencies) Following is a sample of my pivot : I choose : I get: All I...
12. ### Weighted Average

I am trying to find out how many shares of stock I can purchase based off the following: A) Total money available to spend on stocks is \$100. B) I want to buy two stocks. C) Stock #1 price is \$10. D) Stock #2 price is \$20. The question is this... How many shares can I buy if I can only...
13. ### Weighted excel formula yes,no,na

I'm working on a contact center quality score card that has yes, no, and na answers. each line item has a different weight with lines e12,and e13 if answered no should result in the entire form auto zero regardless of the other answers, if answered yes will be valued at 15 points each. The na...
14. ### Subtotal with Sumproduct and Criteria

Looking to calculate a weighted average if there is a rate in column B, and then to be able to filter on other columns and have the subtotal update with the correct weighted average rate. Below is a copy of the formula I have thus far, where column B lists the rates and column A lists the...
15. ### Conditional weighted average

Would anyone know how to work out the weighted average P Year based on the Area field for any given Species in the table below where Land Use can be either High Forest or Windblow and Forecast can only be F? I can do this with sumproduct but am not sure how to have more than one allowable...
16. ### Conditional Weighted Average with Multiple Variables

Hey guys, Spent about 5 hours or more trying to figure this out.. I don't see myself completing the formula without help. I need the weighted average for [(P) Storeys] where the following criteria are met: 1: [(C) Approved] = "Pending" 2: [(O) Approved] = "Pending" 3: [(O) Approved]...
17. ### How to back into a weighted average?

<tbody> I need help calculating a weighted average rate for a specific value. I know value 226 has a weighted average of 0.33920. How would I calculate this, given the criteria below? Thanks in advance for your help, it is much appreciated. <colgroup><col width="77" style="width: 58pt...
18. ### Find Avg of weighted values, dependent on multiple criteria, with weightings in 3rd table

Hi Guys, First post, hope I'm doing this right! I have Table1 which contains the values I need to Average into a column in Table2. The selection of rows in Table1 for the Avg is based on multiple criteria matching every row of Table2. My problem is with solving the requirement for me to use...
19. ### Finding Weighted Average

Problem: We searched a total number of cases (total cases searched) and found errors in x number of cases (cases found). The average errors in those number of cases found is "average mistakes per case". These cases were searched using 3 different softwares: Non-CAC, CAC, and Legacy Scrubber...
20. ### Sumproduct of Sumproduct / or / Sumproduct of Sumifs

Hello guys, I have been working on a file for quite sometime, and I finally hit the wall. I simply cannot find a workaround to the following question. I have an original table that i was able to summarize using index(match) so now the new table looks something like this <tbody> Product Prod...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...