# weighted average

1. ### Calculating weighted average excluding blank cells

Hi everyone, I have a question that I've been trying to figure out and hoping the community might have some tips. For my individual stock portfolio, I'm trying to calculate a weighted average in cell D21 that excludes cell C6 and D6 from the weighted average calculation (SOFI). How can I do...
2. ### Vlookup and Weighted Averages

Need some help here! Two part question here possibly. I am not very efficient with excel yet so please bear with me! I hope the sample file link works, if not I attached an image where I combined sheet 1 and 2 into one to show an idea of what I am working with. SAMPLE FILE 1. I need to find...
3. ### Weighted Averages ignoring blanks and unrelated columns. For Google Sheets

Hi! I am having a lot of trouble calculating a weighted average and ignoring blank cells. I understand what to do if the data is in an array, but I am working on a scorecard that will be printed out. The odd formatting is making it very difficult for me to use the sumproduct function and...
4. ### Explaining cost-weighted and value-weighted returns

Hello: I have the following returns for a sample stock portfolio. When I use cost-weighted gains, the return for the total portfolio is -28% and the return for the sum of all stocks on a cost-weighted basis is also -28%. I get how to explain that. But if an investor wants to use current market...
5. ### Weighted average with multiple weights

Hi All, I am a beginner in excel and am working with a large data set that contains products for individuals and whether they have them, or not. Currently, I am calculating a weighted percentage for the score an individual has for each category for products. I have attached an image of a very...
6. ### Weighted Average Rankings dynamic selections of which values to count

Here's my spreadsheet. Objective: Get a [cumulative] Weighted Ranking of Plants by including only specific individuals' ranks for plant types. Disclaimers and needs to keep in mind: 1. No Visual Basic / Macros 2. I'm using Excel 2010, which means no FILTER, along with a few other functions...
7. ### Weighted average zeroes

Hi guys. I have a crazy file where weighted average being calculated. Now, unfortunately it is a file made to a specific format so we couldn't use sumproduct on the two ranges. Rather the formula looks something like this...
8. ### SUMIF Forumula

I am having a brain fart. I know this is a simple formula but for some reason, I cannot get it. I have a sheet that has multiple information. I want to be able to do a sumif column "A (Period)" has 2021.01 and column "H (Ops Work Center)" has RVR101MA, RVR102MA, RVR103MA, RVR104MA, then sum...
9. ### Weighted Average with different criterias

Hello, I am trying to find the weighted average of 2 or more cells with different words. I can't seem to find the correct formula. I want to find the weighted average of everything with the word MA in it, in the Work Center column. I can't seem to get the correct formula. Work Center...
10. ### Weighted average reverse

I am calculating weighted average based on BENEFITS (60%) and EFFORTS (40%) and give a total score. Example table: CRITERIA WEIGHTAGE SCORE BENEFITS 60% 10 EFFORTS 40% 1 TOTAL SCORE 100% 6.4 For EFFORTS I want weighted calculation to be reversed, so, lower number should show...
11. ### Weighted Utilization % in Pivot based on Volume, Plant & Product Group

Hi All, Really hoping for some help here in calculating the correct weighted utilization. The idea is you have multiple plants within each product group and within each plant you have multiple lines with different possible volumes. Based on the volume assigned to the line you have a...
12. ### Weighted Average

Hi, I have survey data that have 3 questions for each manager, and what I need is to get the weighted average of Favorable Percent for all of these 3 question for each manager. Can you tell me how can I accomplish that? Below is a sample table of the data, knowing that some employees they...
13. ### 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...
14. ### 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...
15. ### 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...
16. ### 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...
17. ### 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...
18. ### 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...
19. 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...
20. ### 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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back