weighted average

  1. B

    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...
  2. J

    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...
  3. E

    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...
  4. D

    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...
  5. szita2000

    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...
  6. M

    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...
  7. M

    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...
  8. 1

    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...
  9. V

    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...
  10. Z

    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...
  11. Z

    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...
  12. M

    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...
  13. B

    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...
  14. E

    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...
  15. A

    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...
  16. G

    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...
  17. 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...
  18. A

    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...
  19. D

    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...
  20. Y

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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