weighted average

  1. R

    Weighted average with sumproduct and multiple conditions

    Hi, I made a formula that works: =SUMPRODUCT(Answer!U2:U65535,Answer!AD2:AD65535)/SUM(Answer!AD2:AD65535) however, I need to update it for multiple conditions and I'm having some trouble with the specifics. Referencing sheet "Answer", I want to perform the same calculation as above but for the...
  2. F

    Standard Deviation & Weighted Average

    I need to calculate the standard deviation and weighted average of a large set of data. A sample of the data: Job Title Frequency Rate Proj Mgr 1 4 22.00 Proj Mgr 1 2 22.53 Proj Mgr 1 5 21.13 Proj Mgr 1...
  3. D

    How to calculate weighted average with multiple criteria

    Hello, I have figured out how to calculate the total weighted average in my data sheet with this formula: =SUMPRODUCT((DATA!AA285:AA20000)*(DATA!N285:N20000))/(SUM(DATA!N285:N20000)) Now I need to figure out, how I can calculate this with two criterias; 1) DATA!AH285:AH20000=Distrikter!C3 2)...
  4. R

    Dynamic Weighted Averages

    I have a powerpivot table with 2 years of data. I am trying to use a measure function in excel pivot tables to calculate a weighted average of revenue generated weighted by sales volume. Ultimately My data is split into 4 fields Sale Date Sales Method Sales Volume...
  5. J

    Complex weighted average calculation

    I have a spreadsheet with the following data (sample): What I am trying to do is the following: I want to calculate the average Conversion rate for each Unit per Month for the ABC Core Product Customers will only have one Core Product, either ABC or something else. If the customer does not...
  6. G

    Formula to adjust for variable quantity

    I would like help in creating the formula that would weigh a third number: Each month, I collect the following data. I would like to be able to create a weighed conversion rate: ..........Showings......Contracts.........Listings......Conversion Rate...
  7. D

    SUMPRODUCT() challenge: Spanning multiple worksheets

    Hello. I am trying to calculate a weighted average from 2 sets of data: 1 set is an array in a worksheet, and the 2nd set is a range of values that share a specific location across multiple worksheets. I was trying to use the following (example) formula to calculate the weighted average from...
  8. J

    Subtotals and Weighted Averages

    I have a set of data that I ran Excel's embedded Subtotals function in the Data tab and used the Sum function in column "I" for each change in column "B". I am wanting to do a weighted average of column "L" based on column "I". I found this set of code in the forum that should take of this...
  9. Y

    Weighted Avg, omit text from calc

    I have a need to calculate the weighted average spread based on whether the date in a column ("N") fits a given date criteria (and some other criteria). If text as opposed to a date is in the column, the result changes. I would like the option of having a date or text in that cell and have the...
  10. H

    Very tough weighted average/logic problem

    I'm trying to come up with a weighted average formula for commodity futures curves. The end goal is to produce a confidence band for where future commodity prices will be. If I simply use a formula that rolls off each futures contract at expiry, the confidence band looks jagged on a graph...
  11. D

    Conditional Sum and Weighted Average using VBA

    I am trying to write a VBA routine to combine certain rows using Excel 2007. I have a table with columns PartNo, Type, Customer, Data, Qty, Price. Data is sorted by PartNo, Type, Customer. When multiple rows have the same PartNo, Type, Customer, I want to combine these rows into a single row...
  12. D

    Simplify a Weighted LOOKUP and SUM Formula

    Hi, I am in need of a simpler formula, I should clarify, a less clumsy formula. I have developed a weighted average emission factor for each pollutant and power setting using INDEX and MATCH. The weighting values are based on the number of tests on one sheet, and the corresponding emission...
  13. A

    Pivot Tables and Weighted Average (Excel 07)

    I am trying to get a weighted average of each CPT in my Pivot Table for Excel 2007. Can anyone help me? Please keep you answers in simple terms (I am not as experienced). I'm also new to the website, so I apologize if this is posted incorrectly! Here is what my pivot table shows (The XXXX...
  14. B

    vba random number generator w/weighted averages

    I currently have the following code to generate a random number between the constraints of B9 and B8 (dynamic): Randomize MyValue = Int((Range("B9") - Range("B8")) * Rnd + 0.5) + Range("B8") As it currently is calculated, each number in that range of B8:B9 (ex: 1-4) is weighted equally...
  15. J

    Weighted Average Formula in Excel

    Needing to reduce the size of the formula below used to calculate the weighted average, I've tried using your suggestion of {=SUMPRODUCT(A1:A10*B1:B10)/SUM(B1:B10)}. However, using this formula gives me different value than the longer formula below...
  16. P

    Custom Formula in Sub-Total

    I appreciate all I find in these forums and after searching for hours I don’t think I’ve found what I’m after completely this time but have found all the parts of the problem. (I’ll apologize in advance if I missed this answer.) So now, how to put it all together? <?xml:namespace prefix = o ns...
  17. A

    Excel 2003 - Maximum Percentage formula...

    Hi everyone - huge thanks in advance to anyone that can offer some assistance with this problem. I have a 6x5 matrix with a series of data in it. It is as simple as this: Row 13: 0 1 2 3 4 Row 14: 0 1 2 3 4 and this is repeated over for 6 rows. The figures in each cell can increase or...
  18. S

    Pivot table and weighted average

    I am trying to get a weighted average from a pivot table and I am trying to use insert calculated field. Currently I am getting the pivot tables and copying those in a regular spreadsheet to do the weighted average calculations. Very time consuming!! 00000000000-000014 9,300 253,692...

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
Back
Top